" is not a valid name. Make sure that it does not include invalid characters or..." error

hi,

i keep on getting this message: "is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long." when i try to import an excel file...

there are no invalid chars or anything of that sort in the file name. the file name is "Korea Jul'12 All Account"

at first i thought it might be due to the apostrophe sign so i renamed it to "Korea Jul12 All Account" but it still gives me that error msg.

Anyone knows what happened?

Thankss

no blank columns and it ends at the actual data when i pressed ctrl+end

even when i change the name of the file to something else, it still says "Korea Jul"12 All Accounts$ is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long."

my file name is Korea Jul'12 All Accounts. But for some reason, when i try to import it to access it keeps on giving me the above error message with Korea Jul"12 All Accounts$ as its filename... why is that???

file name... i am totally confused with this... i have changed it to something really simple multiple times (e.g. "korea account", "korea AllAccounts", etc) and it still doesnt work...

i am so frustrated right now. feels like banging my laptop...

i think this is one of those access glitches. coz there were times when it would run but there were more times where it would not run... i dont know what causes this... i find myself praying (literally) whenever i run the query...

I had a similar problem with Access 2007. I was receiving the same error message ("is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.) when I tried to modify any query using Design View. I could edit using SQL View but Design View simply would not work.

I finally solved the problem by reviewing all of my linked tables and removing one old and unused linked table. I believe another piece of the this puzzle was that my database had been moved from one network location to another. I think this problem began after the move. Once I removed the linked table the Design View problem was gone. None of these queries used that old linked table so it is odd that it affected the design view but that definitely appears to be what was causing my problem. Hopefully this information will help others who encounter the same issue.