ASP.NET, SQL Server, WPF, C#, VB.NET

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 
 
"Paul in MN" <Paul in MN@discussions.microsoft.com> wrote in message 
 
news:968CE88A-2CC3-415D-975E-84A6E44FE0D4@microsoft.com...