as far as i know (checked that issue in the past) there is no way to select a table with SystemDataOleDb from excel file using SQL query if headers are not placed in row 1 the solution for me is to delete all the rows above the header row before querying the worksheet just opening the workbook with MicrosoftOfficeInterop deleting the extra rows, closing it and than querying itTo include the worksheet name on every sheet Start on the first worksheet, and highlight all the others by holding the control button and clicking each sheet name This will apply the footer to all the sheets at once so that you don't have to set each sheet individually Go to the Page Layout, Page Setup menu and click the Header/Footer tabTo add a header and footer in your worksheet, follow the next steps 1 On the Insert tab, in the Text group, click Header & Footer Excel displays the worksheet in Page Layout View You can also click Page Layout view on the status bar to display this view 2 Click the left, center, or right header or footer text box at the top or at the
Headers And Footers In A Worksheet
