Can someone help a beginner please. I tend to do things by trial and error, as I’m not experienced enough to remember from the last time
I’m trying to import a txt file into a temp table from where I can do some other work on the data. I therefore need to ensure the table is blank before I import.
The import code I am using works perfectly until I delete data then it doesn’t work
Can anyone help please.
Ta
Function ImportClipData()
‘Turn warnings off
DoCmd.SetWarnings False
‘delete any existing records
DoCmd.RunSQL “DELETE * FROM tbl_imp1”
‘Import rawData
DoCmd.TransferText acImportDelim, , “tbl_imp1”, “D:ColinDataScLiveListssclivet26.txt”, False
End Function
