Append multiple tables

[dSurvivalist]

Hello all,

I am importing .xls files "CVA*.xls" to seperate tables. 1 table for each file. what i need is a code that appends all these tables with names begining with CVA* to one master table. can anyone help?
thanks!

 

[namliam]

Check out the DOCMD.TRANSFERSPREADSHEET command in the help, it allows you to set the input file AND the target table.

 

[HGMonaro]

dS, never used it but you can get the tables in a db via the tabledef structure. Involves looping through testing each to see if they look similar to what your expecting. Some searching about tabledefs will turn up how to do it. However, since this is part of your other thread, why don't you do the append as you load in the file because you know it's name at that point.

 

[dSurvivalist]

Yes HgMonaro good point! the files have .dbf extension and my knowledge on importing is yet limited to texts and spreadsheets and their specs
a method to import multiple files with this extension also would work well..