How to import table into access?

[cogivina]

I have a table that need to import into access. The problem is that the minus (-) sign in the amount field causing the issue. The data looks like this: #####-

A 1.20-
B 505
B 61.5-

How can I import this into Access correctly? I'd like the data field to look like this:

A -1.20
B 505
B -61.5

Thanks.

 

[dhookom]

Import the records into a temporary table first. Use text for both fields. Then use an append query to append the temporary records into a permanent table. You can use an expression like:

Val([ImpFld]) * IIf(Instr([ImpFld],"-")>0,-1,1)

Duane
Hook'D on Access
MS Access MVP

 

[cogivina]

Thanks for the code. Can we do it in one step because it is a big table?

 

[dhookom]

I have a table that need to import into access. " What kind of table? Is it another Access or other table that you can link to? If so you can create the link and use the calculation in an append or make table query.

Duane
Hook'D on Access
MS Access MVP