Importing csv file using a macro

S

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
 
K

Ken Snell

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