How To fetch records from xlsheet

[raghvendrapanda]

hy, I want to fetch records from xlsheet...i used the following query in my local server DECLARE @SQLconnect VARCHAR(8000), @FileName varchar(256) SET @FileName='C:\CopyofOTFormat.xls' SET @SQLconnect = 'SELECT * INTO ##tmpOrders FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'', ''Excel 8.0;Database=' + @FileName + ''', ''SELECT * FROM [Sheet1$] '')' PRINT @SQLconnect -- SELECT * INTO ##tmpOrders FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=F:\data\export\excel\Top10.xls', 'SELECT * FROM [Sheet1$]') EXEC (@SQLconnect) SELECT * FROM ##tmpOrders SELECT COUNT(*) FROM ##tmpOrders -- 2452 DROP TABLE ##tmpOrders It works in my local server but when i run it in the online server...it says that the xlsheet could not be found. Is there any way i can access it in online server without actually saing it over there Thanks & Ragards raghvendra panda

[Lost User]

raghvendrapanda wrote:

Is there any way i can access it in online server without actually saing it over there

The online server needs access to the "F:\" drive that you're referring to in your connectionstring. That means that the Excel-sheet needs to be saved on the machine that's going to read it.

I are Troll :suss: