Hello:
The problem that I'm having is that when I import data into an Access table
from Excel some of the values are converted to scientific format. Below is
the text from an Access discussion board on this. I've tried converting the
data to text, but it still goes scientific on me. I'm dealing with 1000's of
rows of data here so my going in and placing a comma before each record isn't
feasible unless someone can tell me a shortcut way to do this.
Any help is appreciated!
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
"RobertM" <[email protected]> wrote in message
news:[email protected]...
> 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.
Bookmarks