I'm trying to create an import routine, where a user can identify up to 5 columns on a spreadsheet to import.
My goal is to:
(1) Allow the user to browse to an Excel Workbook and select it.
(2) Display the first 20 or so lines of the main sheet for the workbook that they browse to
(3) Have them on the Access form identify which column has the part number, which column has the quantity, and so on...
(4) Then have them specify which row to start importing.
(5) Figure out how many rows there are in the spreadsheet. Display that on the Access form as a check figure.
(6) Pull those columns/rows into a multicolumn list box for verification
(7) If okay, pull the data into SQL table
(8) Count the records imported, match to check figure from step (5).
My biggest hangup has been just getting the window showing the Excel spreadsheet showing on the form. I feel like the rest of the logic I have already done in other projects.
Any tips/suggestions would be greatly appreciated...
