Importing large number of files with macro

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hello,

I need to import approximately 230 text files into
access. Is there any way using a macro that would be to
import all 230 at one time. For instance, is there a way
to import a whole folder or something like that.

Thank You
 
Mike,

As far as I know, you would need to do it one at a time. You could
certainly have a single macro with 230 TransferText actions, one for
each of your text files. If the text files had a systematic naming
pattern, you could probably use a VBA procedure rather than a macro, to
simplify the process using looping logic to import the files, but in the
end, they are still getting done one at a time.
 
I was looking for a way to avoid having to create the 230
TransferText actions in one macro, because this is a
process which needs to be done every quarter and having to
set up the 230 individual TransferText actions every
quarter is what I am trying to avoid. I was looking for a
way to import an entire folder at one time.
 
Back
Top