Hello,
I previously asked a question about importing data from a csv to MS Access, found here:
http://www.experts-exchange.com/Database/Miscellaneous/Q_26781566.html
During this thread, someone asked me if this would be a one time thing, or repeated.
To which I answered, one time - but I've found out since then that it will be a repeated action after all.
Someone suggested using: DoCmd.TransferText transfertype:=acImportDeli
m, _
tablename:="tblMonthlyData
", _
FileName:="D:\Documents\Ex
amples\Mon
thly Data.csv", _
hasfieldnames:=False
But I would like a step-by-step procedure as to how to do this if possible.
(Screenshots would help please)
Thank you
For example. Lets say my Access table has 15 fields, but I only want to import 5 fields from my csv. How would I go about this?