Apend Table "A" to Table "B"

[RaunLGoode]

I have a named range in workbook "Workbook-A.xls" called "TableA" I would like to add the contents of "TableA" to the end of "TableB" on "Workbook-B.xls".
These tables could be pretty big ( 25 col x 1000 rows).
What is the fastest way to do this while ensuring data integrity? If possible could someone please provide a code example along with the solution?

 

[lemo]

perhaps i am not understanding - can't you just copy-paste one to the bottom of the other? 25x1000 is not big.
l

 

[RaunLGoode]

Yes, I could use Cut and Paste to do this, but I was looking for another way. I have been trying to learn about ADO, this seemed like it might be a better solution. It seems like using ADO would be much quicker and more efficient than opening, pasting, saving, and closing a file, am I wrong? When would something like ADO be appropriate and when would Cut / Paste be a better choice?

 

[chergh]

Cutting and pasting is what I would use.

I only use ado in spreadsheets when I want to use SQL for data manipulation. Maintaining a spreadsheet to use ado also requires a bit of set up as when you add and remove data you need to keep the named ranges upto date.

 

[RaunLGoode]

Thanks! I really appreciate the feedback. I think the strength of forums like this is the feedback of a wide variety of users. Some of the other people I work with feel ADO is vastly superior to using Cut and Paste or Queries for data import/export. For now I would rally like to understand using ADO better.
I would appreciate any additional feedback on Pros & Cons of Cut & Paste, Querying ADO or any other methods of larger volume data transfer between Excel files. Again, Thanks