Link to home
Start Free TrialLog in
Avatar of synergyconsulting
synergyconsultingFlag for United States of America

asked on

Access 2007 Export spec not found when running doCmd.Transfer Text

I keep getting the error: Run-time error 3625:  The text file specification "Myspecname" does not exist. You cannot import, export...
I have done this before and no problem, but after hours of expermentation, I'm still stuck with this error.   Perhaps some debug tips would be helpful.  
Thanks,
Brent
Dim txt_appdir As String
    txt_appdir = CurrentProject.Path
    DoCmd.TransferText acExportDelim, "Export-qa_StreetSync Export", "qa_StreetSync Export", (txt_appdir) & "qa_StreetSyncExport.txt"

Open in new window

SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of synergyconsulting
synergyconsulting
Flag of United States of America image

ASKER

This was a version issue.2007 does not use the spec.  I don't remember how I found the answer, or where.   Thanks to those who replied.  I will try to be more attentive to responding and closing in future posts.
Brent