Problems with imported data

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.
 
M

MH

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
import excel data - scientific notation 1
Problems importing data types 3
Importing via TransferSpreadsheet, receiving "type conversion fail 1
Import errors importing Text into existing table, header vs no hea 3
Trying to import 12 digit number into Access 6
Importing XML Data in Access 2003 1
Import failing on decimals 1

Top