Error on export to txt via saved specs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Need to export daily data to a external program. This program request data
in txt format limited on Fixed width without both text Qualifier and Field
Delimiters.
It seems the export wizard also looks to the Delimited specs even when
Limited is selected. So i have set the Delimited specs to (Field Del.= blanc
and text Q = {none}

Manual export goes well but when I use VB I get errormessage 3341:
Fieldseperaror of spec match Decimal symbol or text Q.

Used Vb string:
Private Sub Label82_Click()
DoCmd.OpenQuery "QryUpdateTblTPGExport"
DoCmd.TransferText acExportDelim, "TPGExportSpec", "TblTPGExport",
"C:\Repairbase\TPGExport.txt", True
DoCmd.OpenQuery "QryEmptyTblTPGExport"
End Sub

In update Qry popups must be filled in so I can't export a select Qry in one
time to txt (as far as my knowledge goes).
After export to txt I run a delete Qry to empty tbl.

Hope anyone can help me.
Tx in advance,
Dirk
 
Oeps,

Think I'am still a bit sleepy ...
Used acExportDelim instead of acExportFixed.

Br,
Dirk
 
Back
Top