I need to import the contents of a MS Excel File into an Access 2010 Table.
Attached is code that I have developed that imports most of the data however it doesn't import all of it.
I need to import the contents of columns B through AP and rows 5 through the last row containing data.
The attached code only imports data from columns E through AP. Changing the Starting Column in the code does not solve the problem.
The Excel File is generated in another application that I don't have control over but remains stable for at least year.
To use the application, start up the 2010 Import Group - Sections Detail Report.accdb file and follow the instructions.
The Input file is: Input File.xls.
The Message line displays 'Imported' when the run is complete.
The 07_IMPORT_DATA Table contains the data when loading is complete.
How can I get this application to load all of the data in the required columns (B - AP and rows with data.