Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Saudi Arabia
    Posts
    1

    Unanswered: How can I read set of specific Excel cells to MS Access table?

    How can I read set of specific Excel cells to MS Access table?

  2. #2
    Join Date
    Sep 2003
    Location
    Gloucester
    Posts
    28
    You can LINK the spreadsheet to your database.

    To Link go

    File
    Get External Data
    Link Tables

    Select files of type .XLS

    Navigate to your Spreadsheet and select

    Answer the questions provided by the wizard and its done.

    You will then be able to query the spreadsheet for the data required - make that an append query and it will update the required table.

Posting Permissions

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