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 ????