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

We try to save msg in got the error in outlook 2021/office 365 0
How can I name an imported excel spreadsheet 1
Need Help with Macro Security 1
Active Content in this file is blocked issue 1
You don't currently have permission to access this folder 0
Integrating information from Word to Excel (not mail merge) 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Template with fields and premade texts.. 0

Top