how do i convert text to number

[Guest]

Can any body helo, Im trying to export a text file into Access and there are
two columns that refrence amounts. How can I convert these two number format

 

[Jeff Boyce]

Del

Use a query to "get" what you want to export. In the query, use CInt() (or
CDbl() or CCurr() or ...) to "coerce" the data into a number. Export the
query (Access will export the results of the query, i.e., the data).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Can any body helo, Im trying to export a text file into Access and there are
two columns that refrence amounts. How can I convert these two number

format

 

[Guest]

Joyce,

I think I worded this wrong Im trying to import a txt file from access and
there are 4 numeric columns in the txt file that should come accross in
number format how do I do this.

Cheers
Del