[Refined Mind]

Alright. Here it goes. I've know how to do a basic transfer of a query into Excel, but my problem is that I need to figure out how to make it so that it doesn't dump the whole query onto one sheet. This has 780000+ columns and it needs to be spread over thousands of sheets in the Excel Document. If there is someone out there who could help me with this it would be greatly appreciated. Either that or tomorrow I continue my copying and pasting. The whole process should take all day plus =(.

[Elite]

I'd guess you need to figure out how to make excel limit the number of columns per sheet.

I'm not sure how to do that.

P.S. What the hell are you doing?

[Refined Mind]

Elite, on May 15 2009, 01:34 AM, said:

I'd guess you need to figure out how to make excel limit the number of columns per sheet.

I'm not sure how to do that.

Right. Me neither dude. I guess that it is just going to be a hell of a long day at the office tomorrow. Thanks for the response though.

[Elite]

What are you doing again, btw?

[Refined Mind]

Elite, on May 15 2009, 01:40 AM, said:

What are you doing again, btw?

I work at a place that writes training programs for a multitude of different things. I am supposed to seperate each course into its own sheet, then put the lesson names and the questions that go with them into the corresponding sheet. Right now the only method that works to do this is to copy and past all the lessons and questions into each individual sheet. It is going to be a very tedious process.

[LeadingMan]

No way to dump it into a comma seperated value?

[Ikari Warrior]

What are you transferring the query from? It sounds to me like it's coming out as a flat file and you need to parse it. Excel 2003 has a "text --> columns" feature under the "data" menu, I believe.

You're not going to get 780,000+ columns into a single excel sheet, I guarantee that. You have at most 676 (A-ZZ) columns, and 65536 rows, which would result in over 1000 excel sheets.

I would do the following:
1) Break up your query (if possible) into reasonably-sized chunks, such that you are well within the reasonable limits of excel
2) Ensure the FORMAT of each broken-down query is consistent, i.e. every column is "X"-characters long.
3) I would recommend using the "record macro" feature, and use the "text-->columns" feature, such that you can break each sheet down into something legible at the press of a button.

It will still take all day, but you could be done by tomorrow, rather than a month from now.

[Binary Baltar]

you could make it a .csv and write some perl to turn it into a .xls, or just manually open the .csv and save it as a .xls