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

[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

 

[Ken Snell [MVP]]

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