none
Display sections of Excel on Access Form RRS feed

  • Question

  • 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...

    Monday, July 1, 2019 2:28 PM

Answers

  • Steve - Can you just link to the spreadsheet and go from there?

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Marked as answer by Steve Hanzek Monday, July 1, 2019 3:00 PM
    Monday, July 1, 2019 2:41 PM

All replies

  • Steve - Can you just link to the spreadsheet and go from there?

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Marked as answer by Steve Hanzek Monday, July 1, 2019 3:00 PM
    Monday, July 1, 2019 2:41 PM
  • Yeah, looks like that is the approach... using a bound object frame... thanks...

    Monday, July 1, 2019 3:00 PM
  • If the spreadsheet has a table-like structure you could even link to it as if it were a table.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Monday, July 1, 2019 5:56 PM