SELECT * into #Table FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database="file excel"','SELECT * FROM [sheet1$]')
"Selamat Mencoba"
Import data excel pada sql server
Query untuk memasukan data dari excel ke sql server :
SELECT * into #Table FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database="file excel"','SELECT * FROM [sheet1$]')
SELECT * into #Table FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database="file excel"','SELECT * FROM [sheet1$]')
Subscribe to:
Posts (Atom)
