Connect to Excel spreadsheet ???

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

Guest

Hi,

* This may not be related to .NET but I can't find a more active group to
post to. *

I have successfully connected to a MS Excel XP spreadsheet via the VS.NET
Server Explorer, however, when I expand the Server Explorer tree of my
connection, no tables show up. I was told that I need some VBA code in my
Excel spreadsheet to tell it what the tables are, or to point out a
worksheet as a table, or something.

Can anyone help ?!

Thank you,
Steve.
 
On Sun, 28 Dec 2003 21:23:44 -0000, <-> wrote:

¤ Hi,
¤
¤ * This may not be related to .NET but I can't find a more active group to
¤ post to. *
¤
¤ I have successfully connected to a MS Excel XP spreadsheet via the VS.NET
¤ Server Explorer, however, when I expand the Server Explorer tree of my
¤ connection, no tables show up. I was told that I need some VBA code in my
¤ Excel spreadsheet to tell it what the tables are, or to point out a
¤ worksheet as a table, or something.
¤

Are you using the Jet 4.0 OLEDB provider? Did you set the Extended Properties (All tab on Data Link
Properties dialog) to Excel 8.0?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Thanks folks, I needed to set "Extended Properties" to "Excel 8.0" as you
said.

Paul Clement said:
On Sun, 28 Dec 2003 21:23:44 -0000, <-> wrote:

¤ Hi,
¤
¤ * This may not be related to .NET but I can't find a more active group to
¤ post to. *
¤
¤ I have successfully connected to a MS Excel XP spreadsheet via the VS.NET
¤ Server Explorer, however, when I expand the Server Explorer tree of my
¤ connection, no tables show up. I was told that I need some VBA code in my
¤ Excel spreadsheet to tell it what the tables are, or to point out a
¤ worksheet as a table, or something.
¤

Are you using the Jet 4.0 OLEDB provider? Did you set the Extended
Click to expand...
Properties (All tab on Data Link
 
Back
Top