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!
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.