Exporting Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top