importing excel

A

AccessUser6969

When I try to import and excel file (2003) I have a column with text
and numbers. It comes in as a text column but the numbers are not
importing correctly. A number like 5233000085 comes in as 5233e
+0009. I have tried working with the excel first formatting but
haven't had any luck.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing an Excel File 1
Importing Text Fields in Excel 2
Importing text into number field- Error 4
Importing Excel Data Into MS Access Memo Field 2
importing text and numbers from excel 3
Type conversion error importing from Excel 5
Blank fields importing from excel 1
How do I correct "Type conversion Failure" in Access 2007 2

Top