Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing Excel worksheets into Access tables (MS Access 2000)

    I have an Excel Work book that has a sheet for each day of month, with a summary sheet that is in the following form:

    Department Dept # 1/1/3 1/2/3 1/3/3
    Open 1 $$$$ $$$$ $$$$
    League 2 $$$$ $$$$ $$$$
    Shoes 3 $$$$ $$$$ $$$$
    Food 4 $$$$ $$$$ $$$$
    Drink 5 $$$$ $$$$ $$$$
    Beer 6 $$$$ $$$$ $$$$

    I want to transfer the data to an Access database table. There will be a table for Departments (Department and Dept #), and a table for Transaction where each record will have Date, Dept#, and $$$$ that corresponds with that intersection in the Excel spreadsheet. Is there a way to transfer this data to an Access database will having to do it manually?

    Thanks in advance for your help.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Importing Excel worksheets into Access tables (MS Access 2000)

    There are at least a couple of ways. On is to use the TransferSpreadsheet command which will bring in an Excel worksheet, and then run a series of queries against the table to transform it. The other is to link to the data from Excel and then run a series of Append queries to build the table. The latter may be a bit more attractive, depending on how frequently you need to run the process and how much data is involved.
    Wendell

Posting Permissions

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