I've got a HUGE database to create. I have 60 GB worth of excel files or so I need to combine and the first 6 rows are things such as company name, which machine created the spreadsheet and so forth. The field names are on row 6. How do I make it so the wizard knows my fields names are on row 6 and the data needed starts on row 7? I would go into the original files and delete them, but I'm not allowed to manipulate the data, not to mention it's 60 GB worth of files and that alone would take forever.
Also side note, When I combine two spreadsheets in a query, will the database understand to put a N/A or whatever in the value if one spreadsheet has an extra field name?