How to import negative currency into Access

[sumdumgai]

I'm having trouble importing a negative currency number into an Access database. I now understand I have to first import the data as text and then run an update query to convert the text to numeric (double). Can someone please elaborate on how this update query is constructed and executed? Thanks.

 

[AccessMSSQL]

What format are you importing from? Excel, txt, csv? Are you allowing Access to create the imported table for you or are you importing into an existing table?

http://www.accessmssql.com/

 

[sumdumgai]

Importing from a .txt file. The table already exists and is being overwritten with each import. I want to create an import specification that I can call afterwards for subsequent imports. Thanks.

 

[gemma-the-husky]

there should be no issue importing a negative, so how is the number structured

eg

-123.45 is probably a negative number

but 123.45- may be treated as text, rather than a mnumber