-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
' ' is not a valid name
- Thread starter tcnt9176
- Start date
-
- Tags
- import excel
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,795
- Office Version
- 365
- Platform
- Windows
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.
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.
Upvote
0
Padawan018
Board Regular
- Joined
- Sep 29, 2006
- Messages
- 63
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,
Thanks,
Upvote
0
Upvote
0
Padawan018
Board Regular
- Joined
- Sep 29, 2006
- Messages
- 63
Upvote
0
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.
Upvote
0
Similar threads
- Solved
