R
RL
Good morning,
I have an Access 2007 Form which contains a Command Button with an Embedded
Macro as an On Click event. The first macro action is Transfer Text, which
exports the contents of a Select Query to a CSV file using the following
arguments:
Transfer Type: Export Delimited
Specification Name:
Table Name: UpdateInformation
FileName: \\Server01\PublicData\etc...
Has Field Names: No
HTML Table Name:
Code Page:
The appropriate number of decimal places for each field are specified within
the 'UpdateInformation' query. Run the query in Access and each field has the
appropriate number of decimal places, whereas the CSV file reverts back to 2
decimal places (viewed in Notepad or Excel).
This has not always been the case - when I first created the tool, the
appropriate formatting was maintained in the CSV file. Does anyone know what
may have changed?
Many thanks in advance,
RL
I have an Access 2007 Form which contains a Command Button with an Embedded
Macro as an On Click event. The first macro action is Transfer Text, which
exports the contents of a Select Query to a CSV file using the following
arguments:
Transfer Type: Export Delimited
Specification Name:
Table Name: UpdateInformation
FileName: \\Server01\PublicData\etc...
Has Field Names: No
HTML Table Name:
Code Page:
The appropriate number of decimal places for each field are specified within
the 'UpdateInformation' query. Run the query in Access and each field has the
appropriate number of decimal places, whereas the CSV file reverts back to 2
decimal places (viewed in Notepad or Excel).
This has not always been the case - when I first created the tool, the
appropriate formatting was maintained in the CSV file. Does anyone know what
may have changed?
Many thanks in advance,
RL