Join Sql Table and Excel Sheet

[imtmub]

Hi,
I am trying to link sql table field and excel sheet column.

SELECT wko_itemid, imc_qty, ima_price
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Documents and Settings\mohammed\Desktop\wkotesting.xls;IMEX=1',
'SELECT * FROM [sheet2$]') inner join dbo.imc on
dbo.imc.imc_itemid= Sheet2.wko_itemid inner join dbo.ima on
dbo.ima.ima_itemid =dbo.imc.imc_itemid

But i am getting error message "The column prefix 'Sheet2' does not match with a table name or alias name used in the query".

Please Help me to link sql table field and excel sheet column.

Thanks

[imtmub]

Still i didn't get any slution. Please help me out

Hi,
I am trying to link sql table field and excel sheet column.

SELECT wko_itemid, imc_qty, ima_price
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Documents and Settings\mohammed\Desktop\wkotesting.xls;IMEX=1',
'SELECT * FROM [sheet2$]') inner join dbo.imc on
dbo.imc.imc_itemid= Sheet2.wko_itemid inner join dbo.ima on
dbo.ima.ima_itemid =dbo.imc.imc_itemid

But i am getting error message "The column prefix 'Sheet2' does not match with a table name or alias name used in the query".

Please Help me to link sql table field and excel sheet column.

Thanks

[azimmer]

Hi,
I am trying to link sql table field and excel sheet column.

SELECT wko_itemid, imc_qty, ima_price
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Documents and Settings\mohammed\Desktop\wkotesting.xls;IMEX=1',
'SELECT * FROM [sheet2$]') inner join dbo.imc on
dbo.imc.imc_itemid= Sheet2.wko_itemid inner join dbo.ima on
dbo.ima.ima_itemid =dbo.imc.imc_itemid

But i am getting error message "The column prefix 'Sheet2' does not match with a table name or alias name used in the query".

Please Help me to link sql table field and excel sheet column.

Thanks

I'm not 100% sure it works but have you given a try to

SELECT wko_itemid, imc_qty, ima_price 
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
               'Excel 8.0;Database=C:\Documents and Settings\mohammed\Desktop\wkotesting.xls;IMEX=1',
               'SELECT * FROM [sheet2$]') Sheet2 inner join dbo.imc on 
dbo.imc.imc_itemid= Sheet2.wko_itemid  inner join dbo.ima on
dbo.ima.ima_itemid =dbo.imc.imc_itemid
 

[imtmub]

I tried but still its giving the error like 'OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.'. I don't have idea what kind of error i am getting. Anyhave i am googling untill i will find solution.