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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top