Problems importing data types

[BBAL20]

I can't figure this one out. I'm trying to import data from excel into a
pre-existing table I have in Access already. The table has the same column
headings and number of columns that the spreadsheet has. It is an exact
mirror of the spreadsheet. I have a number data type column with 16 digits in
excel. The column that I try into keeps importing as a scientific number. The
Access coulmn is a number coulmn as well. I've tried changing it from a long
integer to a double number type and it still doesn't work.

 

[Jeanette Cunningham]

Hi,
if the number is a decimal, you can try setting the data type to decimal.
Set up the precision and scale to the number of digits you need.
In A2003, I don't know of any other way to display 16 digits for double or
single data types except with scientific notation.


Jeanette Cunningham

 

[BBAL20]

That doesn't really work. My value is in a number format in excel
(ie:4170020200028640), but in Access it changes it to a different format
(ie:4.17002020002864E+15). I've tried making that coulmn every different type
of data format available even text. Access either turns it into a scientific
number like the example listed above, imports nulls, or imports 0 depending

 

[Jeanette Cunningham]

In A2003 and below, the import process from excel into access does a sample
scan of the column and the import process determines the data type for
itself. The import process does not take any notice of the data type you set
in excel.

If you don't want to do arithmetic on these numbers you are importing, I
would suggest to import them into a text field in Access.
If this is acceptable to you, here is a trick to play on the import process
to make it import your numbers as text.
It is very simple - in the first row of the data, insert a new row above
the first row of data and type a word like apple - it must look like a word
and not have any unusual characters.
Now import the data to a text field in access.
Delete the row with the word apple in it.

If you wish to put these numbers into a number field, I don't know any way
to display them without scientific format.

Jeanette Cunningham