How would you load a connection string from Ole DB Excel into a SQL Server table?
Posted on 2006-06-26
I am looking to load information from an Excel spreadsheet into a SQL Server table. Using the OLE DB connection string with Excel(we'll call this Excelsheet1.xls), I would like to insert information into tblINFO1 in SQL Server from a database called BIZ. If the record is already in the table, I would like it to update that record. Please let me know how this would be done. Thank you!