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