I run this code and run error:
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'SELECT * FROM [Sheet1$]') select Region_name, department, job_title, employee,
cell, business, extension, home, vip
from DBtest1.JUT.dbo.Test order by 1,2,3
The file is there I checked,but excel is not installed on the server what that matter?