Excel - Read in list of Sheet Names from Script

[joshabbott]

I've been having some terrible issues trying to get this to work.  I need to create a connection to an excel spreadsheet and pull the names of the sheets into a QlikView table.  I've seen many examples how to do this:

http://community.qlik.com/thread/61585

I've got a connection that works to my spreadsheet:

OLEDB

CONNECT32 TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\TEST.xlsx;Mode=Read;Extended Properties=Excel 12.0;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=37;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False];

and then I try to use the code that is supposed to bring in the sheet names as a column:

Temp_Tables:

sqltables;

But this just brings back a qlikview table with 0 rows that have these columns (TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, TABLE_GUID, DESCRIPTION, TABLE_PROPID, DATE_CREATED, DATE_MODFIIED, DATASOURCE).

Is there anyone that might be able to help?

I'm attaching a sample qvw

[maxgro · Accepted solution]

PFA

[joshabbott]

You are my hero!  Thank you!