I have 589 excel comma delimited files to import into one access database. Is there a way to import multiple files or maybe to iteratively import them within access? Or is there a way to append all of these files as an excel file and then import that into access? Can anyone tell me what the best way to approach this would be? I appreciate the help
Thanks z
...if you have access to a linux box, or the 'cat' command (or for win9x/2000 download cygwin or maybe the cat.exe somewhere):
cat file1 file2 file3...fileN >> master
now you have it all in one file. Just one way to do it -- it should work.
The copy command can do this.
Something like:
copy file1+ file2 file3 + file4file.out
I haven't used DOS/WIN in years so verify this before trying.
Can the importing program handles wildcards such as:
importer file*.dat
To : "the phpbigot" and "bluelip"
Thank you for your help I appreciate it. I used the copy command in the Dos shell and it worked. Thanks again
-Z
