Connect to Excel spreadsheet ??? - PART 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Thanks to Paul Clement & William Ryan, I've connected to my Excel
spreadsheet by using the "Jet 4.0 OLEDB" provider and by setting "Extended
Properties" to "Excel 8.0". Although the connection is prefixed with
"ACCESS" rather then "EXCEL", I can successfully use the VS.NET Server
Explorer tree to browse my Excel "tables" and see my data.

However, I cannot seem to drag & drop this connection from the Server
Explorer tree to the component tray. An error message box prompts "data is
not stream". Any ideas what this means and how I can sort it out?

I need to connect to an Excel spreadsheet and then use this connection to
contruct a DataAdapter in turn to construct a typed DataSet so I can work
with Excel data using the VS.NET enviroment rather then writing ADO.NET
code.

More help needed !

Thank you,
Steve.
 
Steve,

What you running into is a known issue with Excel and Server Explorer.
Please see the following article that talks about this issue in details:

PRB: Cannot Configure Data Connection to Excel Files in Visual Studio .NET
http://support.microsoft.com/?id=316831

Please let me know if you have other related questions or concerns.

Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
 
Back
Top