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
Post by Mitchell_Collen via AccessMonster.comPost by Jeff BoyceWhat 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
Post by Mitchell_Collen via AccessMonster.comI am trying to convert a file type: File to Excel and then import into Access.
[quoted text clipped - 4 lines]
Post by Mitchell_Collen via AccessMonster.comthis? 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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200712/1