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
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