conversion problem

[Mitchell_Collen via AccessMonster.com]

I am trying to convert a file type: File to Excel and then import into Access.
I have a field that has some numbers in it, some numbers in the column come
across as 3.123232323E + 11, or 2.34343434 E +11 Do you know what would cause
this? The rest of the data converts perfect. Please advise.
Thanks, Misty

 

[Jeff Boyce]

What is the data type of the field that holds these unusual values?

Perhaps what you're seeing is simply a matter of the format in which Access
is displaying the value (it looks like scientific notation to me...)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mitchell_Collen via AccessMonster.com]

What is the data type of the field that holds these unusual values?

Perhaps what you're seeing is simply a matter of the format in which Access
is displaying the value (it looks like scientific notation to me...)

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am trying to convert a file type: File to Excel and then import into
Access.

[quoted text clipped - 4 lines]

this? The rest of the data converts perfect. Please advise.
Thanks, Misty

The type is unknown. It is supposed to be a unique 8 to 11 digit number to
identify medications. When I import into access it is a number type. I
thought that it could be scientific notation also but it strange because the
numbers do not come across this way in the software that produces them. How
should I import them or is there another way? I don't have access to the
software that produced the numbers.

Thanks, Misty

 

[Jeff Boyce]

Instead of importing into Access and letting Access decide, create a table
in Access with the data types you need. Link to the data source. Create an
"append" query that takes from the data source (linked) and writes to the
permanent table you created, changing data types as needed...

For example, you have an identifier (e.g., code, ...) that Access is
treating as a number. Just because the identifier uses digits doesn't make
it a number data type ... take a look at US zip codes. They look like
numbers but they are never added/subtracted/...

Regards

Jeff Boyce
Microsoft Office/Access MVP

What is the data type of the field that holds these unusual values?

Perhaps what you're seeing is simply a matter of the format in which
Access
is displaying the value (it looks like scientific notation to me...)

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am trying to convert a file type: File to Excel and then import into
Access.

[quoted text clipped - 4 lines]

this? The rest of the data converts perfect. Please advise.
Thanks, Misty

The type is unknown. It is supposed to be a unique 8 to 11 digit number to
identify medications. When I import into access it is a number type. I
thought that it could be scientific notation also but it strange because
the
numbers do not come across this way in the software that produces them.
How
should I import them or is there another way? I don't have access to the
software that produced the numbers.

Thanks, Misty

 

[Mitchell_Collen via AccessMonster.com]

Instead of importing into Access and letting Access decide, create a table
in Access with the data types you need. Link to the data source. Create an
"append" query that takes from the data source (linked) and writes to the
permanent table you created, changing data types as needed...

For example, you have an identifier (e.g., code, ...) that Access is
treating as a number. Just because the identifier uses digits doesn't make
it a number data type ... take a look at US zip codes. They look like
numbers but they are never added/subtracted/...

Regards

Jeff Boyce
Microsoft Office/Access MVP
[quoted text clipped - 23 lines]

Thanks, Misty

Thanks! -Misty