numbers.txt to currency table in access

[CP]

Hi: Is there an easy way to import a text file that contains numbers (e.g.
10000) into an access table as a currency $100.00. It seems to be coming in
as $10,000.00. Thanks.

 

[pietlinden]

Hi: Is there an easy way to import a text file that contains numbers (e.g..
10000) into an access table as a currency $100.00.  It seems to be coming in
as $10,000.00.  Thanks.

you mean divide by 100? use an update query after your sure that's
what you want. And make a backup of your table first, in case
something bad happens.