643 text files to be automativally imported to access

  • Thread starter Thread starter Rick Elbanna
  • Start date Start date
R

Rick Elbanna

i have 643 files, all identical with same delimeter and 8 fields, i tried to
import then one by one and it is very unoractical. is there a way to do this
automatically at one shot.
 
Rick Elbanna said:
i have 643 files, all identical with same delimeter and 8 fields, i
tried to import then one by one and it is very unoractical. is there
a way to do this automatically at one shot.
Click to expand...

Are you importing them all into the same table? You could do it using
code, using the Dir() function to loop through the files in a folder and
call DoCmd.TransferText for each one. Or you may be able to use the
Copy command in a Command Prompt window to concatenate all the files
into one big text file, and then manually import that file.
 
Back
Top