Joining 50 tables 2

[Sandman007]

I have 50 dbf files I would like to join. Any suggestions on how to do it? I havent' played with Access in ages. I need a little help. Thanks.

 

[HBWAL]

Do you mean you want to merge all the files into 1 table? Do they have the same headings?

 

[Sandman007]

Yes, same headings.

 

[Sandman007]

Yes I would like to get into one table. They have the same headings.

 

[HBWAL]

I use code to bring in csv files. They are located in a staging folder and I pick them up, check to see if they've been imported already, if not put them in a List Import table, I keep a file log of files i've imported so I update that table, and the fileId of the listimport table and then move them to the completed folder. This code loops through all the files in the staging folder that has the "strsearch" text and imports them. Do you think you could make this work?

 

[livvie]

you could import them into a new table in another DB and then import the new table back to your DB

 

[Sandman007]

thanks. I think both will work. I'll give it a shot.