First I'm developing in Access 2010.
I am struggling with code that is supposed to create a text file and populate it from a query. The Query "cbt_Candidate_Export_Temp" is working fine but I keep getting the error in the second argument:
"Run-time error '3625': The text file specification 'cbtTab' does not exist... "
DoCmd.TransferText acExportDelim, "cbtTab", "cbt_Candidate_Export_Temp", "\\denali\nbcc\databases\BCC\CBT_Export\" & strFileName & ".txt", True
What object is "cbtTab"? I didn't write this base code and I can't find it nor do I know how to create "cbtTab"
Thanks in advance!
Creating a text file from VBA and exporting data to .txt
I am struggling with code that is supposed to create a text file and populate it from a query. The Query "cbt_Candidate_Export_Temp" is working fine but I keep getting the error in the second argument:
"Run-time error '3625': The text file specification 'cbtTab' does not exist... "
DoCmd.TransferText acExportDelim, "cbtTab", "cbt_Candidate_Export_Temp", "\\denali\nbcc\databases\BCC\CBT_Export\" & strFileName & ".txt", True
What object is "cbtTab"? I didn't write this base code and I can't find it nor do I know how to create "cbtTab"
Thanks in advance!
0 commentaires:
Enregistrer un commentaire