Creating An Excel Chart from Answers Generated in A VB DBgrid

Hello,

I am using VB 5 to generate an SQL query to extract data from Access 97 to populate a DBGrid within a user interface.

My question is, how would I go about converting the answers from the DBGrid into a Excel 97 chart or graph ????

Any advice, code or links would be greatly appreciated.

Thanks very much,
Andy...............

Check "ADO and DAO Tips" at http://edc.bizhosting.com/english/index.htm