Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011

    Unanswered: Importing Excel into Access

    Hi there,

    I currently have a simple vba function which assists me with importing my excel spreadsheet into pre-defined tables in access. But I want to make it more professional.

    This is my current code:

    docmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel7, "tblname", "myfilename", True
    What I want to happen is once the import button has been clicked a windows folder/dialogue pops up for you to select the file you wish to import.

    Is there a way to do this?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    probably by expanding the macro
    otherwise you will have to go down the route of using a VBA procedure, and probably some of the generic windows controls or possibly the file system object
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2011

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts