469,326 Members | 1,345 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

Importing from Excel

G
I have an excel document that has a field called Account Number.
I have an equivalent field in an Access database.
When i import the field info from the excel sheet to access, only some of
the numbers come through. It seems like numbers with over 9 digits do not
come through.
In the access destination table, the field size in the account number field
is set to DOUBLE. I have tried to set it to LONG INTEGER but still no
success.
Help.

I have have tried to replace the excel sheet with an access database
thinking that i could simply import the account numbers from this temporary
access database into my existing access database.
However I notice it does not transfer the account numbers from the temp
database directly into my "account number" table of my existing database.
All that happens is that the table (from the temp access database) is
recreated in my access database (in the tables section).
Nov 12 '05 #1
1 2461
Try using a Text field.

Pavel

G wrote:

I have an excel document that has a field called Account Number.
I have an equivalent field in an Access database.
When i import the field info from the excel sheet to access, only some of
the numbers come through. It seems like numbers with over 9 digits do not
come through.
In the access destination table, the field size in the account number field
is set to DOUBLE. I have tried to set it to LONG INTEGER but still no
success.
Help.

I have have tried to replace the excel sheet with an access database
thinking that i could simply import the account numbers from this temporary
access database into my existing access database.
However I notice it does not transfer the account numbers from the temp
database directly into my "account number" table of my existing database.
All that happens is that the table (from the temp access database) is
recreated in my access database (in the tables section).

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.