TransferText command for saved import steps... why not working?

[rdougherty]

Hello,



I am hoping to automate a few imports for a database in order to remove manual steps.

I have used this process before, but for some reason, it is not working in this database:

Public Sub Import()

Const ImpSPec1 = "Received"


    DoCmd.TransferText acImportDelim, ImpSPec1, "tbl_Received", "\\redacted\corp\shared\redacted\Forecast_Reporting\raw_data\redacted\Received.csv", False
    
Exit Sub
End Sub

Even though I have a saved import for .csv which tests successfully on its own, named "Received", this code provides the error that: "The text file specification "Received" does not exist." And "received" is spelled correctly in all places, btw :P

Do you see any issues with what I"m doing?

[rdougherty]

NVM, I think this is "solved", since I just discovered that https://msdn.microsoft.com/en-us/vba...-method-access suggests that we use RunsavedImportExport method instead.

[ssanfu]

Strange.

Don't see anything wrong with the command.

This is what I have been using for more than 10 years without any problems:

DoCmd.TransferText acImportDelim, "HoursImportSpecification", "tblHoursImport", strFileName, True

The variable "strFileName" is the drive, path and filename from a file dialog file picker. The files are CSV files.