Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: Import Access or CSV file to Excel 200

    I was wondering if someone could point me in the right direction. I have to import data from a Microsoft Access Query into Excel; however, for each line of data, I need to create 3 lines of data.

    For example, my Access Query spits out:
    Name, A, B, C, D, E

    I need to create 3 lines in an excel file base on the query like,
    Name, A, B
    Name, B, C
    Name, E

    I need to do this for import to a Peachtree Accounting database.

    Anyway, I think the best way to accomplish this is to export my query to a CSV file and use VBA code from there; however, I am having trouble importing it the way I need it. Can someone just start me down the right path?

    Any help would be appreciated.

    Thank you!

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Rather import to CSV, why not import through your Excel queries already set (Data > Import External Data > New Database Query), and then use the macros in Excel to do what you want on another sheet? This has the advantage of being easier to troubleshoot, as well.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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