Export to Text File Using DoCmd Access 2007

[tonere]

I have created an export specification "Export-T_GRS_Section_1_Part_B_Upload" that will export an Access table to a text file as a fixed width file.

I am trying to put the code to do this in a module, and I found the following code, but it returns the run time error 3625 "The text file specification "Export-T_GRS_Section_1_Part_B_Upload" does not exist. You cannot import, export or link using the specification".

Thank you in advance for reviewing this!

Function Send2TextFile()
DoCmd.TransferText transfertype:=acExportFixed, _
specificationname:="Export-T_GRS_Section_1_Part_B_Upload", _


tablename:="T_GRS_Section_II_Part_B_Upload", _
FileName:="W:\Instres\IPEDS\2009-10\T_GRS_Section_I_Part_B_Upload.txt", _
hasfieldnames:=False
End Function

[ajetrumpet]

try using:

docmd.RunSavedImportExport

instead. if that doesn't work, your spec might not be in the list anymore. check it via the ribbon menu.