Failed to retrieve data for this request.

I am trying to load data into a SQL Server table through a web page. I am getting error like this:

Error: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

I am doing the same for other tables in the same db its working fine. but its working for one table alone. The table name is like this (DTD_PUMA_DeliveryPerformance)

Is it cos of table name?

I tried with import/export wizard also its working fine but still its not working for web page.

I don t think its cos of network or OS!! Its with table or some connection property.

Pls help me in solving this.

There is nothing wrong with the tablename.

Have you checked the connection string and compared it to the one on pages that are successful?

|||

Thanks for the reply.

Identified the problem, its cos of the excel sheet.

There is a row in the excel sheet with the description ("Get Keys"), when i removed tht row its working

So i need to know how to exclude the first row from the excel sheet while selecting (select * from [Sheet1$]).