Format Text

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

I have information I import from an excel spreadsheet. The
dollar amounts come in from excel as text.
Example $343.50 comes in as 34350
I need to format the imported information to show
currency. If I try to format the number as currency it
shows as $34350.00
I have also tried creating an input mask (######.00!) and
that works but when I search on the currency field I have
to search for the blanks too.
Can anyone help me out?
 
Instead of importing the data into a new table, import it into an existing
Access table that's been set up to accept it. Create the dollar amount
column in Access as a Currency datatype. When you import the data to that
table, it will automatically convert it to the Currency datatype, no input
mask necessary.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
I have tried several times to import directly into an
existing Access table and it will not let me. It will
create a new table each time I try to import.
Each month there will be a import done and I do not want
several tables in the database.

May be I am doing it wrong. I go to File-Get External
Data and choose the dbf file from the CD. I go throuh the
steps and it will just automatically create a new table
and not import into an existing table.
Any thoughts?
 
Back
Top