Export from Database to Excel
 

here is my dilemma

I have an Oracle database that consists of tables (duh!) for an award nomination project
where I have a table for nominees and a table for each category of qualifications
for example

table 1 (nominees)
name
ID_NUMBER PK
DEPARTMENT
NAME
PHONE#


table 2 (education_information)
ID_NUMBER FK
DEGREE
STARTDATE
ENDDATE
INSTITUTION

etc..


I need to know how can I take these records from the tables ans export them to an Excel file where the output (Excel File) will look something like this:

--------------------------------------------------------------------------------------------------------
ID_NUMBER | DEPARTMENT | NAME | PHONE# | DEGREE | STARTDATE | ENDDATE | INSTITUTION
--------------------------------------------------------------------------------------------------------


I'm using ASP.NET VB.NET

So please ,HELP!

My project is due next week :S

Re: Export from Database to Excel
 

read the data to a gridview and write it to the excel table.

http://vb.net-informations.com/excel...e_to_excel.htm

it may help u.