Hi,
My name is Adam. I trying to determine if there is anyone out there can help me with an easy solution to my problem.
I have been asked to collate some 3000 plus *.dbf files (each named differently) into a/1 Access'97 table. When individually importing a "dbf" file into Access, there is only 1 table (which only has 1 row) I only need from each "dbf" file. The table is the same name throughout each of the "dbf" files.
Has anyone come across something simular to this in their tracks and has a solution.
The only I can seem to bring in the data is doing each file individually.
Cheers
Adam X-)
My name is Adam. I trying to determine if there is anyone out there can help me with an easy solution to my problem.
I have been asked to collate some 3000 plus *.dbf files (each named differently) into a/1 Access'97 table. When individually importing a "dbf" file into Access, there is only 1 table (which only has 1 row) I only need from each "dbf" file. The table is the same name throughout each of the "dbf" files.
Has anyone come across something simular to this in their tracks and has a solution.
The only I can seem to bring in the data is doing each file individually.
Cheers
Adam X-)