Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For Each vFile in FileList('[Recording Sheet]')
ODBC CONNECT32 TO '[Excel Files;DBQ=$(vFile]';
Sheets:
SQLTABLES;
DISCONNECT;
For i = 0 To NoOfRows('Sheets')-1
Let vSheet = left(Peek('TABLE_NAME', i, 'Sheets'), len(Peek('TABLE_NAME', i, 'Sheets'))-1);
LOAD '$(vSheet)' as [Tab Name], *
From [$(vFile)]
(ooxml, embeddd labels, table is $(vSheet));
Next;
Next
this is what i have and it is still not loading the data
A missing parenthesis:
ODBC CONNECT32 TO '[Excel Files;DBQ=$(vFile)]';
Dollar expanding the variable i might help:
Let vSheet = left(Peek('TABLE_NAME', $(i), 'Sheets'), len(Peek('TABLE_NAME', $(i), 'Sheets'))-1);
To be honest I don't understand why you're removing the last character of the sheet name. That could prevent the load statement from finding the right excel table.
For Each vFile in FileList('[Recording Sheet]')
ODBC CONNECT32 TO '[Excel Files;DBQ=$(vFile]';
Shouldn't you give a path to an excel file here? I also think the single quotes are not correct and you are missing a closing ];
Hi,
the following is what I am trying to follow from Maxgro: Re: How to load EXCEL worksheets and retrieve tab names
I don't want to remove the last character; I am just following this:
this is what i have and it is still not loading the data