The easiest way to load the first sheet is to reference it by the sheet number using @n syntax:
"table is @1"
I haven't experimented with using ErrorMode to handle column variations. I usually use SQLTABLEs to examine the sheets and pick out what I want. This blog post
shows how to do this and the QV Cookbook has a complete example.
Thanks for the quick reply.
I didn't know that I could use @1 to reference the first sheet. GREAT...just what I needed.
I also downloaded and had a quick look at QV cookbook to see how you handle culumn variations...very interesting.
Looks like this could be VERY helpful to me...a lot of code (and commenting of the code) and interesting stuff.
Using "@" to reference a sheet works very well.
But I am having problem with the SQLColumns technique that I saw in QV Cookbook. This is how I do it...
ODBC CONNECT TO [Excel Files;DBQ='C:\Lists\003_9786438_091219.xls];
But my odbc connection keeps failing, Message...SQL##f - SqlState: 42000, ErrorCode: 4294965487 ...
I'm on windows 7, don't have the regular MS JET drivers installed...could this be the reason? It would be helpful to me if I could know the number or columns in an excel file before I load it. Is there any other way to get this information?
Is there other techniques or ways to get around the problem with loading multiple excelfiles into Qlikview when u have files with different number of columns and/or different column names ?