' ' is not a valid name

[tcnt9176]

I am trying to import an 2007 excel spreadsheet to 2007 access table and I receive this error "' ' is not a valid name."

 

[Joe4]

Sounds to me like you have a column with no header on it. If that is not the case, you may have a blank column that it is trying to import.

Do all of you columns have a header?
If you hit CTRL-END, does it go to the last row/column that you expect? If it goes out further, delete all the blanks columns between that column and the end of your data, save, and try again.

 

[tcnt9176]

that worked!!! Couple of columns had no headers. Many thanks!!!

 

[Padawan018]

I am receiving this error when trying to convert an SAP data dump to a recordset in Excel. I have the named range set to the exact area so I don't have any extra columns. Any help would be greatly appreciated.

Thanks,

 

[Fazza]

cross post http://www.mrexcel.com/forum/showthread.php?t=440277

 

[Padawan018]

Cross Post - http://www.mrexcel.com/forum/showthread.php?p=2175659&posted=1#post2175659

 

[22strider]

It appears that this error is coming up because of many possible reasons. I was able to get rid of it in my case by reducing length of one column heading. During creation of multi level queries didn't realize that the column heading swell to a long string. Renaming the column got rid of this issue for me. By the way I was getting this error when exporting query result to excel.