Exporting is converting dot to hash symbol...

  • Thread starter Flashing CAPS LOCK
  • Start date
F

Flashing CAPS LOCK

Hi all,

I have a access database that when you click a button it will export data to
a .csv

The problem is that the dot is beening exported as a hash symbol and Im not
sure why??

The code

DoCmd.TransferText acExportDelim, , "qryGccExport", filePathExport &
"\AmeyUpdates_" & Format(Now, "yyyymmddhhmm") & ".csv"

DoCmd.TransferText acExportDelim, , "qryGccExport", filePathExport &
"\GO.AmeyUpdates_" & Format(Now, "yyyymmddhhmm") & ".csv"

its the dot after the GO command that is wrong the file it generates looks
like

GO#Ameyupdate_ the date etc.

Im not sure why it is doing this??

anyhelp would be great

Cheers
Patrick
 
Top