Problems with imported data

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

Guest

Hello:

Here's what;s happening:

1. I'm using a macro to import data from Excel to an Access Table

2. The info being imported is a 9 digit text identifier. Sometimes it has
leading zeros, sometimes it has letters mixed in. In the Access table the
feild is text. When the info comes over into the Access table some of the
values appear as shown below:

6.29E+110

This is not good. I need to assure that on the import it dosen't change to a
scientific value.

Thank you.
 
You need to format the cells (in Excel) as text and make sure that Excel
does not automatically change the format to scientific when the data is
entered (as Excel does, and you can't turn this feature off!!!)

If you have problems with this, it may be better to post in an Excel group.

MH
 
Back
Top