Linked Tables Merge

[Bob Fitz]

Ah thanks. Might sound stupid, but in VBA, and native excel, or a result to be held in memory, you need to use an array. If one query creates the table, and you start another query, wouldnt the results be just replaced with the new?

Sorry but I don't understand the question.

.....If one query creates the table.....

I don't see any query that creates a table

[pbaldy]

Post 7 was moderated, I'm posting to trigger email notifications.

[annonymous]

Sorry but I don't understand the question. I don't see any query that creates a table

I cant thank you enough. I've worked out what you mean

Its working