Format problem on exporting a query to txt

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

 

[Ken Snell \(MVP\)]

Use CStr function to cast the numbers as string values:

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