Archive of Mr Excel Message Board

Back to Other Office and Excel archive index
Back to archive home

Import Excel in Access

Posted by Chad on December 20, 2001 2:58 PM

I am trying to import an excel file into Access 97. I keep getting error messages stating a type conversion failure. The occurs in a majority of cells that contian a 9 digit phone number, with no dashes, spaces, or (). I have tried various formats and still cannot avoid the error. Any suggestions?

Re: Import Excel in Access

Posted by Aladin Akyurek on December 20, 2001 3:07 PM

Chad --

Before you import, define/design a table that has eexactly the same fields as your Excel "table". You'll have a field Phone whose data type can be Text. I believe importing into the predefined table will solve your problem.

Aladin

========

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.