ora/vb/excel project

[starlight849]

Hello and thanks for reading.
I am working on a program in vb with an oracle backend. I am calling the data from several different tables in an oracle database into a datatable and then doing some rather simple calculations from there. Once done, I am exporting the data( all single percentages and totals statistics stuff) into an excel spreadsheet. However, I am unsure as to where I should have the calculations take place.
Due to security reasons I cannot share any of the code.I have been researching which way to go with this all morning. Any help or advice is greatly appreciated.

Thanks

[Meggan]

I assume you have already found the answer, but in case you have not, I can recommend the following:

Use the ODP.Net provider from Oracle. It works better the MS one does and MS is getting rid of theirs anyway. (See Microsoft announced its deprecation of System.Data.OracleClient <http://www.oracle.com/goto/newsletters/netdev/0709/msdn_orclnt.html?msgid=8053849>)

Create a view in Oracle and use that. It is easier to manage the view then code that has to be compiled.

In your VB code, don't forget to reference the Excel library.

Without a specific question on the code it is hard to say more.

[starlight849]

Yes, I did find the answer. However, I appreciate the link and suggestions.