I have an Excel file that I need to import into Access. the file is a set format that i am not allowed to edit (or ask to have edited) and contains multiple sheets. I need to pull data from one specific sheet and the data starts on row 6 (header row) and can contain anything from 20 rows to a couple thousand. The Excel file has 119 columns for each data row and not all the headers can be field names in Access. I am in a battle with the project owner to only pull in the 15 columns that are needed in the database and am proceeding down that path..... What I want to do is pull in specific columns and all the rows in sheet (example column A, C, S, AA,.... ) starting at row 7 through however many rows are in the file from the specific sheet. Using the headers in the Excel file may be a problem because there are special characters in many of them. the other "challenge" is not all the fields will be populated all the time (blanks in the data)
In a prefect world, i would have someone move the needed data to an Excel upload template then just pull in the template but the project owner thinks that would be too challenging for the user doing it. Of course the project owner also wants all 119 fields in the table.
any help, guidance, or code examples would be greatly appreciated.