update SQl table from values in excel
Posted
by
user175084
on Stack Overflow
See other posts from Stack Overflow
or by user175084
Published on 2010-12-22T20:07:46Z
Indexed on
2010/12/22
20:54 UTC
Read the original article
Hit count: 292
I am using the SQL Developer or SQl express.
How do i get the values from an excel sheet and update those in a column of my database...
Please help thanks.
i have this and im running it but i get error:
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\books.xls',
'SELECT * FROM [Sheet1$]')
i get error now
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".
thanks
© Stack Overflow or respective owner