I should have been clearer. It is always the same number of rows, I just don't have the file open in front of me to say the exact number....

Getting the supplier to mod the file would be nice and solve tons of problems that we have, however, they established that we will adapt to the data as they...

Steve-

Thanks for the reply. As far as I can find, the Excel connection manager doesn't have that option. It just allows for choice of file, and that's about...

That's what I've been doing as a workaround. The problem is that we're working on building a system that needs to be fully automated by July, meaning that I...

Thanks...I had seen/read that post and made sure I was following that advice. Maybe my questions just suck, though I thought they were relevant and probably stuff others would...

Do I have a problem with the way I post information? I've probably posted 4 or 5 things in this forum that get views, but never any replies. Is...

That's what I was thinking but was trying to see if there was a way in TSQL that I just didn't know about. I'll look into the SP_EXECUTESQL though....thanks...

Figured out the error...thought I'd share for anyone else with the same issue.

Despite the fact that we were logged on to our development environment, Analysis Services was still trying to...