Select ID,Data FROM [Data$]"

  • Thread starter Thread starter cate
  • Start date Start date
C

cate

I'm going thru C# code that connects 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))
 
I'm going thru C# code that  connects 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))
Click to expand...

Got answer from sqlserver group. This is an excel sheet reference.
Thanks
 
Back
Top