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:
Code:
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?