Exporting a query to a CSV file...CC number issue

[caper1175]

Hi all - I have a query and credit card number is a field in this query. I have a macro to export the results of the query to a csv file. However, once it is exported the credit card number in the csv file does not diplay correctly...it displays as an exponent instead of the card number. can someone provide a fix. thanks in advance.

 

[traingamer]

If it is actually an exponent in the .csv file, you should try exporting it as a text field. If it is only DISPLAYING as an exponent in excel or your spreadsheet program, try making the column wider or converting it there...

traingamer

 

[PHV]

In your export query use the Format function for the CC number.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[caper1175]

PHV & Traingamer - thanks for your reply's however I'm still having no luck.

 

[traingamer]

If you open the .csv with a text editor, are the values correct or incorrect?

traingamer

 

[PHV]

Have you tried the Format function ?
Another try to do is to put a single quote on front of the CC number.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[caper1175]

I have opened the CSV file with a text editor and the number appear in the correct format

I have tried the Format Function without any luck. I've also tried appending a ' to the beginning of the cc number, however the ' carries over into the CSV file.

 

[traingamer]

Just go into your spreadsheet and format your credit card number column as 'number' with no decimals and make it wide enough to display the full number. This is NOT an access problem if the output is correct in the .csv file.

traingamer