Importing data with no decimals points in the file

[Guest]

I have received an ascii file from a cobol program that
I'm trying to import into an access table. No matter how I
format the numeric fields it adds 2 zeros when I modify
the field to add the decimal. In the ascii file the
numeric field is "00002750" which represents 27.00 When
importing to access it always makes it 2,750.00 How can I
get around this?

 

[Joe Fallon]

The idea is to import the data to a staging table.
Once it is in Access, review the staged data.
Then write an Append query to massage and move the data to the real table.
You can do division by 100 if you need to in the Append query.

 

[John Nurick]

Either import the data as it comes and then run an update query that
divides the numbers by 100 (i.e. update FieldX to
[FieldX] / 100
)

Or import the data to a temporary "staging" table and then use an append
query to scale it as you move it to the "permanent" table.