Hi, I want to create a connection to an Excel .xls file so I can loop through the data in the sheet inserting the values in to a database. Does anyone know how I can do this??
Use that and then open up the Excel sheet just like a recordset.<BR><BR>-Doug
<BR>Thanks, I'll give that a go. Is there anyway to do it without setting up an ODBC though??
...but not have a DSN.<BR><BR>Craig.
It might have the Excel ODBC driver on it.<BR><BR>http://www.able-consulting.com/ADO_Conn.htm<BR><BR>-Doug
Thats wicked, thanks a lot, should be OK now!!