Page 1 of 1

Import from excel file having 3 tabs

Posted: Sat May 24, 2014 12:15 am
by smantrip
Hello All-

I'm a new to Tm1 and truly need assistance.

The data source for tm1 is from excel. The file is not too large, but 60,000 records in each sheet viz, sheet1,sheet2,sheet3 in one single excel file.
I can process sheet1 without issue. My question is how to simultaneously process all the 3 sheets.

Please advice.

--Srrinivas

Re: Import from excel file having 3 tabs

Posted: Sun May 25, 2014 1:56 pm
by Duncan P
Using the standard XL ODBC driver the sheet name corresponds to the table name in the SQL statement.