I wish to call using, transfertext in vba, an import from csv file to a table.
This works fine by hand and, when saved, works fine from the save.
BUT I can find no way of finding out the name of the import specfications to be used in the statement where I have at present "import-INVFROM SAGE" which is the name in the saved Exports
DoCmd.TransferText transferType:=acImportDelim, SpecificationName:="import-INVFROM SAGE", TableName:="topinvnum", FileName:="C:\!!!!SAGE\2017hire_to_sage\transfersfromsage\INVFROM SAGE.cs", hasfieldnames:=True
Nothing seems to work but there seems to be no way to find out the specification name.
This CANNOT be this hard - so please someone tell me where I am being stupid !!