Import from Excel

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

When I import from an Excel into Access 2003 table, in one field (Text field)
the project numbers appear in a scientific format with exponents. The data in
the field are all numeric but I want the field to be defined as a Text. Is
there a way to avoid the scientific formats. Surprisingly sometimes it worked
fine but I do not know when.
Can somebody help ?

Thanks a lot
dan
 
The Excel has the part number as 300270310 and after import into Access it
appears as 300270310.00 in some cases and in other cases as 3.0270e.xxx. The
field in Access is defined as Text.

The one I could overcome is to change it to Numeric then the data is
imported correctly. But in that case I have to change all other queries
comparing tables etc.... I would like to keep the Access definition for this
field as Text only. Maybe I can change the columns in Excel (Text to data)
and then try to import. But in that case it involves manual intervention. The
field however contains only 9 digits.
Thanks....
 
The Excel has the part number as 300270310 and after import into Access it
appears as 300270310.00 in some cases and in other cases as 3.0270e.xxx. The
field in Access is defined as Text.

The one I could overcome is to change it to Numeric then the data is
imported correctly. But in that case I have to change all other queries
comparing tables etc.... I would like to keep the Access definition for this
field as Text only. Maybe I can change the columns in Excel (Text to data)
and then try to import. But in that case it involves manual intervention. The
field however contains only 9 digits.
Thanks....
Click to expand...

Try inserting a blank row at the very top of the spreadsheet with an
unambiguosly text value. Somehow Excel is assuming that this field must be
converted to a number to import into Access.

Also... double and triplecheck that the Access table field IS in fact text
(and not a Lookup Field or a Number of some flavor). I'm skeptical.
 
Back
Top