 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / August 2006Imported numbers from Excel change to scientific notation
While in Excel I have changed my 10 digit account numbers into text format, and then I import them into Access. Frequently, these numbers do not convert correctly. They get converted into scientific notation and the trailing numbers are lost. While converting Excel into Access, is there some way to keep all the digits intact? Import as text, into a temporary table. Append from the temporary table into the final table structure, using queries. Force the text into the correct (integer, single, double) datatype explicitly with CInt(), ... functions. Regards Jeff Boyce Microsoft Office/Access MVP > While in Excel I have changed my 10 digit account numbers into text > format, [quoted text clipped - 4 lines] > to > keep all the digits intact? This might work but, it is WHILE I am Importing as text into a temporary table that the account numbers are changed to scientific notation format. > Import as text, into a temporary table. > [quoted text clipped - 15 lines] > > to > > keep all the digits intact? I mis-spoke. Create a table with text-type fields. Import into that table (I named it a "temporary" table because it won't be the final version.) This allows you to import values into a known table structure, rather than relying on the wisdom of the wizard to decide. After your data is in the "temporary" table, run the queries that parse and coerce the data into the "permanent" tables with the correct data types. Regards Jeff Boyce Microsoft Office/Access MVP > This might work but, it is WHILE I am Importing as text into a temporary > table that the account numbers are changed to scientific notation format. [quoted text clipped - 21 lines] >> > to >> > keep all the digits intact? It worked. Thanks. > I mis-spoke. > [quoted text clipped - 37 lines] > >> > to > >> > keep all the digits intact? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.