importing from excel turns numbers into exponent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I import data from an excel file some of the numbers turn into exponents
(i.e. 10010023 when imported from excel, turns into 1.001E+007 in access)
The access field is a text field and usually the excel cells are formatted as
text as well but it also happens when they are general fromat as well. Is
there any way to fix this so that it doesn't happen? I am running Access
2000.
 
There are many issues surrounding data formatting when importing data from
Excel. The very best way to avoid them all is to create a table with the
field sizes and data types you want and import into an existing table rather
than creating a new table. One that is not obvious is that when Access
creates the table, the default text field size is used (usually 50 unless you
have changed the default). Using longer than necessary text field sizes is a
negative impact on performance.
So, first delete the data from the Access table then import the Excel data
into it.
 
Back
Top