Hi Guys,

I am a software engineer by trabe but haven't had the opportunity to dabble with VB until now. I have a little project that has been going pretty well until now. Besically the problem is that I have data from multiple SQL queries that has been formatted in a particular way. Modifying the SQL isn't an option as the formatting goes beyond what SQL is meant for. Once I have all the data and have it formatted and stored in my own data type (say a double array of Strings/Variants) I want to display it in a table with certian headers, column sizes,...etc.

What choices are available for the display control in VB? I don't think I can use a basic data grid as I havan't been able to figure out how to designate my double array of strings as the data source. There might be a way of creating an ADODB.Recordset and setting it's row values by hand, but I haven't figured that out yet. Perhaps using an excel spreadsheet in the application would be a solution? I haven't really looked into that yet.

If anyone can offer thier thoughts on this I would appreciate it.