خطا در OPENROWSET

[baraka]

سلام
من براي خواندن از فايل excle از فرمت زير استفاده مي كنم:

select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=D:\GasImport.xls',

'SELECT * FROM [Sheet1$]')


ولي هنگام اجرا خطاي زير رو دريافت ميكنم:

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

لينك زير رو هم خوندم :

http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm#How-To: Import Excel 2007 to SQL Server x86
ولي كمكي به من نكرده ....
ممنون ميشم كسي كمكم كنه فوري.

[tooraj_azizi_1035]

سلام اینو تست کن:
SELECT * INTO tbl
FROM OPENROWSET('MSDASQL','DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);UID=admin;UserCommitSync=Yes;Threads=3;Saf eTransactions=0;ReadOnly=1;PageTimeout=5;MaxScanRo ws=8;MaxBufferSize=2048;FIL=excel 12.0;DriverId=1046;DefaultDir=E:\Project Data;DBQ=E:\Project Data\example.xls', 'SELECT * FROM [Sheet2$]')

[baraka]

با اجراي script نتيجه اي كه برميگرده اينه:
OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".