Import Excel 2007 into Access 2007

  • Thread starter Thread starter Julie B
  • Start date Start date
J

Julie B

I am having a problem importing from Excel to Access and rounding.
Everything is coming in at whole numbers. How can I fix this please? Thanks.
 
Are you importing into an existing table or letting Access create a new
table with each import?

If it's an existing table, how have you defined the numeric fields? The
default "Field Size" property for numeric fields is Long Integer, which can
only hold integer values.
 
I have tried both. Letting Access create a new table and importing into an
existing table. I have made both Acess and Excel have 3 places after the
decimal point. I have formatted both fields so the numbering is the same.

So, now I am going to try to copy from Excel and paste into access.
 
I figured it out. I have to import to a new table, and before I import, the
fields with 3 decimal places, I have to make it a "double" for number type.

Works like a charm. I wrote a little append query to get the data loaded
into the main table.

Life is good!
 
Back
Top