msaidi2 (10/14/2008)
This is passed from vb.net(Executble file) to the Server using this :SELECT * INTO table FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=" +
OpenFileDialog1.FileName + ";Extended Properties=Excel 8.0')...[Sheet1$]
The problem exists when the exe file is not on the server. The path changes. (OpenFileDialog1.FileName )
You sent me another similair procedure in ur link:
select * into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\testing.xls;HDR=YES',
'SELECT * FROM [Sheet1$]')
Is there any difference between them ????
If your file exists in the client system, use UNC
\\system_name\driver_name\file_path
Failing to plan is Planning to fail