Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    69

    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

    Exit_Command0_Click:
    Exit Sub

    Err_Command0_Click:
    MsgBox Err.Description
    Resume Exit_Command0_Click

    End Sub

    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 ?

  2. #2
    Join Date
    Sep 2003
    Posts
    69
    I even tried changing the digit symbol from , to . in the windows settings and still the same error.

  3. #3
    Join Date
    Jul 2003
    Posts
    81
    can you send me some data? Send me an mdb with the query and the specification file to help you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •