Prev: Todays Date in Template Parameter
Next: Multiple Items in Listbox
From: cate on 9 May 2010 10:08
I'm going thru some C# code that iconnects to an excel object. I've
never seen a slq construct like this. Would someone please decipher
the "[Data$]" part? Thank you.

"Select ID,Data FROM [Data$]"
(used in a constructor like: new OleDbDataAdapter(query, connection))
From: Dan Guzman on 9 May 2010 10:55
> I'm going thru some C# code that iconnects to an excel object. I've
> never seen a slq construct like this. Would someone please decipher
> the "[Data$]" part? Thank you.

[Data$] is the name of the sheet within the Excel workbook. See
http://support.microsoft.com/kb/316934 for more information.


--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"cate" <catebekensail(a)yahoo.com> wrote in message
news:db0ec2a7-f2c8-4661-a3ec-01c2195840c1(a)n15g2000yqf.googlegroups.com...
> I'm going thru some C# code that iconnects to an excel object. I've
> never seen a slq construct like this. Would someone please decipher
> the "[Data$]" part? Thank you.
>
> "Select ID,Data FROM [Data$]"
> (used in a constructor like: new OleDbDataAdapter(query, connection))

From: cate on 9 May 2010 11:20
On May 9, 9:55 am, "Dan Guzman" <guzma...(a)nospam-online.sbcglobal.net>
wrote:
> > I'm going thru some C# code that iconnects to an excel object.  I've
> > never seen a slq construct like this.  Would someone please decipher
> > the "[Data$]" part?  Thank you.
>
> [Data$] is the name of the sheet within the Excel workbook.  Seehttp://support.microsoft.com/kb/316934for more information.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVPhttp://weblogs.sqlteam.com/dang/
>
> "cate" <catebekens...(a)yahoo.com> wrote in message
>
> news:db0ec2a7-f2c8-4661-a3ec-01c2195840c1(a)n15g2000yqf.googlegroups.com...
>
> > I'm going thru some C# code that iconnects to an excel object.  I've
> > never seen a slq construct like this.  Would someone please decipher
> > the "[Data$]" part?  Thank you.
>
> > "Select ID,Data FROM [Data$]"
> > (used in a constructor like:  new OleDbDataAdapter(query, connection))

thank you - all clear now.
 | 
Pages: 1
Prev: Todays Date in Template Parameter
Next: Multiple Items in Listbox