Service Desk Practitioners Forum
cancel

SD Import from Excel 2007

SOLVED
Go to solution
Highlighted
Colleen Talbert
Super Contributor.

SD Import from Excel 2007

It's been a while since I've done an import, but for some reason when I run the ECW on my excel file, I keep getting the "Table or view does not exist" error. I have used the instructions for naming the range and it still gives me that error. I have also made sure to save it as an Excel 97 - 2003 Workbook, but no luck. Please let me know what else I can try!

Thanks,
Colleen
2 REPLIES
George M. Meneg
Acclaimed Contributor.
Solution

Re: SD Import from Excel 2007

Hello Colleen,

This is a bug as long as I remember! ECW fails reading the first name range on the excel. Well, the solution is simple, name the range twice using different names. It will fail on the first name (giving the message "table or view does not exist" ) but I will work using the second name.
menes fhtagn
Colleen Talbert
Super Contributor.

Re: SD Import from Excel 2007

That worked! I added another name and then the first name worked. I won't ask why, I'm just happy it ran. Thanks for the quick response!!

Colleen