Help outputting Millions of values to excel? csv?

Hi. I have a program that opens a form, asks the user for some inputs (Variable names, range of possible values, #values in range) then creates all the output values and stores them all in an array. (The array I am using is an array of arrays however it is rectangular.) The program then outputs to excel. The problem is that I need to be able to create up to 5 million combinations and this would take way to long to output to excel. Does anyone know of a better way to accomplish this. The user wants to be able to see results in excel. I have never done anything with CSV files but am thinking that anytime I have ever exported anything of size it has been a CSV file. Is that the path I need to go down? And if so is it as simple as instead of exporting to excel you export to a CSV file?

Any help is greatly appreciated. Thanks

Quote:

---

The user wants to be able to see results in excel.

---

That part is actually easy in Excel, because It supports CSV file for Importing. Wth some VBA coding you might even want to create your own Workbook where user would simply click a button for Import and It would import whatever you want automatically - this way you could even arrange your data to look nicer. I'm not sure how fast that Import works with so many rows though.

As for VB.NET, I'm not quite sure how difficult It is to create a CSV because I've never done It, but I think It should be simple, as seen in this example:
http://stackoverflow.com/questions/2...iter-in-vb-net

But I can help you If you need to create CSV from Excel, and export It into DB or somewhere else. That however is not so easy :)

I need my final data to look like
Variable1 Name Variable2 Name Variable3 Name
val1 val1 val1
val2 val2 val2

Just to be clear, you are saying to...
1) Create a new CSV file
2) Write my values to it
3) Save
4) Create new Excel Workbook
5) Import saved CSV file
6) Format in Excel

Quote:

---

1) Create a new CSV file
2) Write my values to it
3) Save
4) Create new Excel Workbook
5) Import saved CSV file
6) Format in Excel

---

Yes, that is how I would do. But you could create CSV, create Excel, import CSV and format worksheet as you want - If you still want all in one shot. That might work fast too, I really don't know.

Okay I will give it a try. Thank you for the guidance.