var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problems with exporting query to *.csv
I have this query with data I have to export daily to csv so I can upload it to mysql. Now i do it manualy (paste excel save as *.txt .....)
I now want to make this happen automatically.
I think one of the options is a button with VB code behind. But i get an error with this code:
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
Dim AString As String
AString = "File_name_prefix"
DoCmd.TransferText acExportDelim, , "query_name", "C:\file_" & AString & Format(Date, "YYYY_MMDD") & Format(Time, "-HH_MM") & ".txt", False
The fault I get is: Text file specification field separator matches decimal separator or text delimiter
I tried to change my keyboard settings to Belgian comma instead of belgian period but still the same.
Anyone an idea ?
I even tried changing the digit symbol from , to . in the windows settings and still the same error.
can you send me some data? Send me an mdb with the query and the specification file to help you.