VBA Code to load data from a file into a Access table

  • Thread starter Thread starter Karen Middleton
  • Start date Start date
K

Karen Middleton

I have an Access table T000 and a flat file T000.csv in c:\data can
somebody please provide me the VBA code that enables me to load this
file into the above table.

Similarly a VBA code to take data from table t000 and place it into
unloadt000.csv in c:\temp

Thanks
Karen
 
Check out TransferText in Help. It'll do what you want, both for importing
and exporting data.
 
Back
Top