sfmatt13
10-25-2012, 07:53 PM
Hi Everyone,
I originally started with a Microsoft Access Table of data. It is in the shape of one column with 3,500,000 rows of data. I then created a query and exported it as a csv. I'd like to program a macro that pulls data from this csv file. I'd like it to take entries #1-256 and transpose them into row 1 of the spreadsheet, entries #701-756 and transpose them into row 2 of the spreadsheet, entries #1401-1656 and transpose them into row 3 of the spreadsheet, and so on for 5,000 rows.
Since I am very novice at writing macros, run time isn't too big of a deal to me as the simpler/easier to understand macro, the better.
I really appreciate your help in advance! =)
I originally started with a Microsoft Access Table of data. It is in the shape of one column with 3,500,000 rows of data. I then created a query and exported it as a csv. I'd like to program a macro that pulls data from this csv file. I'd like it to take entries #1-256 and transpose them into row 1 of the spreadsheet, entries #701-756 and transpose them into row 2 of the spreadsheet, entries #1401-1656 and transpose them into row 3 of the spreadsheet, and so on for 5,000 rows.
Since I am very novice at writing macros, run time isn't too big of a deal to me as the simpler/easier to understand macro, the better.
I really appreciate your help in advance! =)