Hi All,
I am trying to add the facility for my users to import a CSV file via a button on a form. The code in the on click event of the button is:
But I keep getting the run time error saying 'You cannot import this file'.
The full code for the on click event of the button is below too in case that helps:
Any help is much appreciated.
I am trying to add the facility for my users to import a CSV file via a button on a form. The code in the on click event of the button is:
Code:
DoCmd.TransferText acImportDelim, "ImportTempT", _
"S:\IT\1 - Testing\CSVTestTwo.csv", True
But I keep getting the run time error saying 'You cannot import this file'.
The full code for the on click event of the button is below too in case that helps:
Code:
'Delete existing import info
currentDB.Execute "DELETE FROM ImportTempT"
DoCmd.TransferText acImportDelim, "ImportTempT", _
"S:\IT\1 - Testing\CSVTestTwo.csv", True
DoCmd.OpenQuery "OrgImportQ"
DoCmd.OpenQuery "ContactImportQ"
Me.Requery
MsgBox "Import complete"
Any help is much appreciated.