numbers.txt to currency table in access

  • Thread starter Thread starter CP
  • Start date Start date
C

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.
 
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.
Click to expand...

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