How to load the excel data by using ODBC connection?
I am having one excel "data.xlsx" file. In that am having no of worksheets which contains same field name(column name) in all worksheet. I dont want to write a script for each worksheets. May be in future if they add some more worksheets, it should work if we reload. For that using odbc connection am trying to load the excel file. I want to know which driver i have to use for loading excel file. Am facing issue in connection string .Anyone please suggest me how to solve this issue?
Re: How to load the excel data by using ODBC connection?
Thanks for your reply. Am having sheet name as'Housing Allowance', Transport Allowance', 'Annual Bonus' likewise am having so many sheets which all having different worksheet name. In that case am trying to get lists of all sheets in an excel by using odbc connection and calling SQLTables function.