View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim M[_4_] Jim M[_4_] is offline
external usenet poster
 
Posts: 2
Default Select Data in Worksheet 1

I am able to select data from worksheet 1 if I know the sheet name...

OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM [Sheet1$]",
objConn);

How would I just get the data from the first (primary sheet) if I do not
know the name of Sheet1$ ?

Thanks in advance!