Importing large numbers from Excel to Access

[Glenn_Suggs]

I'm having with an import that involves number that are sixteen digits long. They appear to come in from Excel in scientific notation and all I need on the Access side is a 16-character string that represents the original number. (I need it to be text because that's the way it will be stored on a server side table) However, when I use Cstr(number), it retains the scientific notation format as something like 1.05000345E+15. How can I get the Scientific notation Excel number to convert to "1050003458749878"?

Thanks in advance,
Glenn

 

[alansidman]

Are you able to convert them to text in Excel? If so, then save the file as a .csv file and import the .csv file to Access. The "numbers" should then come over as text.

 

[shg]

If 16-digit numbers are stored in Excel as numbers, the least-significant digit has been irretrievably lost. Excel only stores numbers to 15-digit precision; larger numbers must be held as strings.

 

[Glenn_Suggs]

Are you able to convert them to text in Excel? If so, then save the file as a .csv file and import the .csv file to Access. The "numbers" should then come over as text.

Thanks Alan. Unfortunately the file is sent from an outside source and when I do a "format cells" on the number column, then changing it to text still has the 1.0... e+15 type format. I think I've found a work around, though, so thanks for your time. ...Glenn

 

[alansidman]

Glenn;
If your file that is coming from an external source and it is a text based file, then you can import it directly into Access as text. Just a thought

 

[Glenn_Suggs]

I think I to get the sender of the file, then, to convert the field to a string before sending it to me. Otherwise, I'm stuck with the fowled up number.
Thanks... Glenn

 

[Glenn_Suggs]

Alan... That would be a great idea. However, in my situation, I work with what I get sometimes. (flying by the seat of my pants) If only the differing systems in this rather large company could talk to each other. I'd like to see some "data consolidation" taking place. Imagine that... Glenn