Importing csv file using a macro

  • Thread starter Thread starter Steve
  • Start date Start date
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
 
Check out the TransferText action. It allows a macro to import from or
export to a text file.
 
Back
Top