Importing csv file using a macro

[Steve]

Each day I import a csv file (that sits on my c drive)
into a table in my access database.

I normally use the wizard to import the file, however, I
was wondering whether it would be possible to import the
file via a macro, thus requiring once click to import the
data.

If it the above is possible, then is it possible to
automate it to the extent that it will import at a certain
time each day ?

Thanks
Steve

 

[Ken Snell]

Check out the TransferText action. It allows a macro to import from or
export to a text file.

 

[Steve]

Thank you Ken