sql server odbc: Excel sheetinformation in SQL server 7.0 -- sql server odbc

Excel sheetinformation in SQL server 7.0

Frank Westerbeke
11/24/2003 2:16:37 PM

sql server odbc:

I would like to update a SQL table with information entered in a spreadsheet
..

Can anyone tell me where to start.

Frank

Re: Excel sheetinformation in SQL server 7.0

Rog
11/26/2003 2:31:51 PM

"Frank Westerbeke" <nospam@vaessen-schoemaker.nl> ha scritto nel messaggio
news:bpt07l$v00$1@hermes.castel.nl...
[quoted text, click to view]
Start by looking at linked servers, this allows you to link in any database
with an OLE DB driver and include tables from linked databases alongside
native tables, for example in an INSERT....SELECT.

Of course Excel is not a database but the OLE DB driver for JET allows you
to access a named range of a spreadsheet like a table.