Importing from multiple .txt files at a time

[jl]

For analysis purposes I'd purchased daily NYSE stock trade data for a number
of years. Each year's zip file breaks out into a series of files for each
trade day. I want to import these into access but am trying to think of a
shortcut to doing this one day at a time.

Does anyone have ideas?

Thanks!

Jeff Lynch

 

[John Nurick]

Hi Jeff,

If you search (e.g. at groups.google.com) for

group:microsoft.public.access.externaldata fallon "import multiple
files"

you'll find a sample procedure that Joe Fallon MVP posted a while back
for this sort of task.