Solved Run time error 31519 when trying to import CSV file

[AlliCarr]

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:

    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:

'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.

 

[ebs17]

First of all, you should always use correct and complete syntax.
DoCmd.TransferText (TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

 

[AlliCarr]

First of all, you should always use correct and complete syntax.
DoCmd.TransferText (TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

Thanks @ebs17 It works perfectly since I added in the additional comma to represent the specification name!