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
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?
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!