Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    18

    Unanswered: Import from Excel into Access

    Hi, I want to create a form which, at the click of a button, will import data from an Excel s/s into a new table in my Access d/b. Does anyone have any tips/pointers/code that can help me? Thanks
    "For all have sinned, and fallen short of the glory of God"

    - God speaking through Paul

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    DoCmd.TransferSpreadsheet (?)
    All code ADO/ADOX unless otherwise specified.
    Mike.

Posting Permissions

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