Format problem on exporting a query to txt

P

Pat Coleman

Access 2003

Exporting a query as a text file and I choose CSV and " as text separator.

I need " to wrap the numbers but I cant figure out how to do that.

What I get is

"TAG","Qty"
59081,13
2450,30

What I need is

"TAG","Qty"
"59081","13"
"2450","30"

Anyone know how to achieve this.
 
K

Ken Snell \(MVP\)

Use CStr function to cast the numbers as string values:

SELECT CStr([TAG]) AS tTAG, CStr([Qty]) AS tQty
FROM TableName;
 
Top