Error Importing Excel Spreadsheet into Access

J

Jason

I'm trying to import a general excel spreadsheet into access. However,
everytime I try to import it, it says there is an error importing the data
and that it can not be imported. Also, it doesn't give me any indication to
what type of error it is. I've tried pasting the data into a fresh
spreadsheet and that still didn't reslove the issue. Does any one have an
idea onto why I would be getting this error message?
 
C

Chel

hi Jason-

It could be some of the values in the title of a column such as # and @.
What kind of data are you importing? Time- Dates- just words?
Are there spaces in front of the data in a field? Is there text in a number
field?
Are there any symbols in text or number fields?
 

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

Access Subscript out of range when importing into access 2010 from excel 0
Importing Excel into Access 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing Excel Spreadsheet into Access 1
Importing error 9
Import Excel Spreadsheet 1
Importing From Excel 1
Access 2007 Excel Import Error 1

Top