Importing large number of files with macro

[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

 

[Steve Schapel]

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.

 

[Guest]

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.

 

[BeckyMc]

See if this helps:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;198467&Product=acc

BeckyMc