How to save spreadsheet with error message " is not a valid name

H

Happy

I am trying to import an Excel spreadsheet into Access 2007. When I click
"Finish" I get the error message:
" is not a valid name. Make sure that it does not inlcude invalid charaters
or punctuation and that it is not too long.

I've even reduced the file name to one charater. Not sure why I'm getting
this message or how to go around it.
 
J

Jerry Whittle

Copy and paste the data into a new Excel file. In this new file, make sure
that the first row, if it has the field names, doesn't have any special
characters in the name and are under 54 characters long. Also make sure that
all the columns have something in row A.
 

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

How can I name an imported excel spreadsheet 1
Email Bounce Error 3
Error when importing from excel - not a valid name 3
refreshing linked tables 4
ERROR with no direction on how to fix - " is not a valid name... 5
"is not a valid name. Make sure 7
Split database- linking tables 1
Help needed in linking to tables using Access 2007 1

Top