I have several Excel files that I need to append items from. I have created the tables and have had success in appending the data. I notice that it appends the header record as well. Of course I don't need this data. Other than going in and deleteting the header record by assumming the the field name will always be the same, is there a way to append the spreadsheet without the header?
Some spreadsheets have several headers. I only want the data below the headers. Is there way to do this?
Thanks in advance for your help! :-)
Randall L. Johnson