Started out as an Access problem. Now an Excel problem
 

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" wrote in message
...
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.

Started out as an Access problem. Now an Excel problem
 

After you import to Excel and find scientific notation, re-format those
cells to present the information in your desired number format.

Started out as an Access problem. Now an Excel problem
 

Hi Robert,

If placing a comma before the cell data would do it, how about using a
helper column with the formula : = "," & A1

Where your data is in column A

Copy that formula down for all of your rows.

Would that work?




"RobertM" wrote:

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" wrote in message
...
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.