>Hi larry,
>
> do you have any idea on how to set the recordsource property of ADO control into excel files... i did to connect in the connection string property but it failed to in the recordsource property ... i confuse what to put or what value to put in that property... i hope do you have an idea regarding this matter...
>
>
>
Holden,
Because Excel doesn't have an OLE-DB provider yet, you need to use the default OLE-DB Provider for ODBC. I would recommend setting up an ODBC connection entry for your Excel spreadsheet and specify this when creating the ADO connection. You could do it without the entry and specify everything in the connection string, but it is far easier (IMO) this way.
Ex.
oConn = createobject("ADODB.Connection")
oConn.Open "MyExcelODBCName"
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao