I have 6-8 csv files that I need to import and overwrite existing records in there corresponding table. I thought this was going to be easy but when researching code it seemed more complex then originally thought. My limited experience with vba isnt helping much either. Any help would be appreciated.
This is some of the code that I picked through that I thought would be a rough start.
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM NameOfTable"
DoCmd.SetWarnings True
DoCmd.TransferText acExportDelim, "Standard Output", _
"External Report", "C:\Txtfiles\April.doc"