How to load the excel data by using ODBC connection?
Hi all,
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?
