import specs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm importing Number fields that have no decimal place holder in them. i.e
12300
I want it to appear as 123.00 or even as a currency $123.00 but if I set the
field format to fixed or Currency... it appears 12300.00

Any Ideas on how I could set up the import specification... It does not
allow me to remove the "decimal place designator" from the import specs...
 
D & C,

Access importing what it is seeing. After the import you
will need to run an update query on the table. Something
like [numberfieldname]/100 to convert the imported number
to the correct value. If the import is appending to an
existing populated table be carefull you are not updating
already fixed numbers. You may ned to import into a
staging table, update the import and then append to the
final destination.


HTH,

Terry
 
Back
Top