Creating a text file from VBA and exporting data to .txt

jeudi 30 avril 2015

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

0 commentaires:

Enregistrer un commentaire

Labels