Exporting Fields

D

david

When I export data from an Access2003 table into a txt file all numeric
and/or currency fields are not seperated by "quotes" which is needed to
import that data. Is there anyway this can be completed without changing the
field type to text?
 
T

tina

you can create a Select query based on your table, converting the number
data types to string, and formatting the "currency field" string as Currency
to retain the dollar sign, etc.

SELECT Table1.text1, Table1.text2, CStr([number1]) AS Expr1,
Format(CStr([currency1]),"Currency") AS Expr2
FROM Table1;

hth
 
Top