[Originally posted by suresh]

I have placed a ADO control and MSHflexgrid on a form.In ADODC properites, in datalink , I have given the Datasource Name and Enter the initial catalog to use(Book1.xls).
Test connection is also succeded.
But in "Recordsource", how I have to give the sheetname.

I know to connect an excel using DAO.But I don't know how to give recordsource for Excel datasource in ADO.

Thanks in advance.