| | |
Export from Database to Excel
Please support our ASP.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: May 2008
Posts: 3
Reputation:
Solved Threads: 0
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
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
Last edited by yomr; Aug 21st, 2008 at 3:54 pm.
•
•
Join Date: Jun 2008
Posts: 7
Reputation:
Solved Threads: 0
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.
http://vb.net-informations.com/excel...e_to_excel.htm
it may help u.
![]() |
Similar Threads
- Porblem in UTF-8 support on CSV/EXCEL (PHP)
- Exporting ASP pages to Excel (ASP)
- Pls. Help!!! HOW DO I IMPORT AND EXPORT (VB.NET)
- code to transfer data from mysql to excel sheet (MySQL)
- Export DataTable to Excel with variable number of fields (VB.NET)
- vb 6- exporting a database as an excel file in a tabular format(calendar form) (Visual Basic 4 / 5 / 6)
- Export Data From Excel to ASP and SQL Server (C++)
Other Threads in the ASP.NET Forum
- Previous Thread: adding a line to an invoice form
- Next Thread: working with GRIDVIEW
| Thread Tools | Search this Thread |
.net 2.0 3.5 ajax appliances asp asp.net beginner box browser businesslogiclayer button c# c#gridviewcolumn cac checkbox class compatible confirmationcodegeneration content contenttype control countryselector courier css dataaccesslayer database datagrid datagridview datalist deadlock deployment development dgv dialog dropdownmenu dynamic dynamically edit embeddingactivexcontrol fileuploader fill findcontrol flash flv forms gridview gudi homeedition iis javascript jquery list listbox menu mssql multistepregistration nameisnotdeclared news novell objects opera order problem radio ratings redirect registration relationaldatabases reportemail rotatepage search security serializesmo.table sessionvariables silverlight smoobjects software sql sql-server ssl tracking treeview validatedate validation vb.net videos virtualdirectory vista visual-studio visualstudio vs2008 web webapplications webarchitecture webdevelopment webprogramming wizard xml xsl





