as-400_excel-2013_excel (page 5) Questionssubmit your own question

I want to create a DataSet from an excel without knowing the name(s) of the sheets inside. Is it possible to get the names of the sheets using OLE DB Provider ? So a I can perform several SELECT orde

We connected dot net with as400 but it is very very slow when i am trying bring 1 lakh records

There is some way to limit the number of returned rows?

Hi I learnt from connectionstrings.com that "HDR=Yes" in Connection String for Excel indicates that 1st row is not values but Column Names. I have a requirement where I need to consider 2nd row

I created my connection string in Dreamweaver MX as shown below: <% ' FileName="Connection_ado_conn_string.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="false" ' Catalog="" ' Schema="" D

I'm looking over the Excel examples and see a problem: what if I don't know the exact name of the Excel file I'm trying to open? All of the examples need a full name either in the Dbq or the Data Sour