birdie_nam_nam

Dear very nice VB experts!

I would like to merge data from two separate workbooks into a flexgrid.
The two books contains data in a database structure, that is one line with fild names, and then the posts in sequence under it. One of the fields are named the same, and is the "key" to what should be merged. All other fields should be put into the line in the flexgrid.

I understand, or guess that this is somewhat a tricky task, but I appriciate all hints I can get.

Example of what I mean:

Book 1:

Name ID Age
Seb 1 25
Kalle 2 30
Jenny 3 6


Book 2:

ID City
1 Gothenburg
2 New York


FlexGrid:

Name ID Age City
Seb 1 25 Gothenburg
Kalle 2 30 New York
Jenny 3 6


My first thought was to treat the two books as a relationship database, and to acces it with some nice sql statement. Is this possible?

Best wishes, Sebastian.

Flyguy

Book 2 is merely a simple lookup table (string array) which could be put in memory.
Then when retrieving data from book 1 you replace the ID with the city name from a lookup array.

birdie_nam_nam

Quote:

---

Originally Posted by Flyguy
Book 2 is merely a simple lookup table (string array) which could be put in memory.
Then when retrieving data from book 1 you replace the ID with the city name from a lookup array.

---

Thanks for replying so fast!

OK, the tables in my examples was simple examples. The real tables are both in Book 1 and Book 2 Tables with a lot of columns, and with a lot of rows. But you think that this is the way to do it anyway? To read in a 2-dimensional array, and to look up the correct row?

/Sebastian.

Flyguy

Maybe you can ADO and SQL for it, but I would first try the most simple approach, just create a lookup table in memory to connect the rows in Book1 with the rows in Book2