Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Posts
    146
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing Excel Info (2000 SP-3)

    Hi,

    I'm trying to create a database from some Excel information. Unfortunately, the Excel info that I want to import is set up with field labels running down the left side, instead of across the top. The column headings are for different weeks.

    For example, one worksheet is four cells wide. Left to right, there's a field label, and then field values for three different weeks.

    Does anyone know any tricks for getting this info into Access and then setting it up in a table (with Week values one value of a record)?

    Thanks,
    Bob

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing Excel Info (2000 SP-3)

    Could you post a workbook with examples of
    - What the Excel data looks like.
    - How you want it to look in Access.

  3. #3
    2 Star Lounger
    Join Date
    Jun 2001
    Posts
    146
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Excel Info (2000 SP-3)

    Here you go. Worksheet 1 is an example of the Excel layout, and worksheet 2 shows how I'd like the Access table laid out.

    Thanks,
    Bob

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing Excel Info (2000 SP-3)

    You don't want a Field Category field in the result, since it doesn't have a single value. I have attached your workbook with a macro that will populate the table in the second sheet. You can import this table into Access.

    Note: I formatted column A in the second sheet as dates manually.

Posting Permissions

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