Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SD Import from Excel 2007

SOLVED
Go to solution
Highlighted
Colleen Talbert
Collector

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
Honored 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
Collector

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
//Add this to "OnDomLoad" event