Using an Excel File as a data source, have set up ODBC and created a data set, but Excel has multiple tabs.

SQLServerCentral » Latest topics

Using an Excel File as a data source, have set up ODBC and created a data set, but Excel has multiple tabs.

Hello,

I have set up a data source in VS 2010 using an Excel (2010) Document, through an ODBC that I created. Now, when I set up the data set, I put in...

Select * from [tabname1$]

...I did this 3 times, so I have a data set for

more info...