473,320 Members | 2,162 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

exporting data from ms-access to excel worksheet using ASP.

Hello

How to export data from ms-access database to excel worksheet using ASP.
mainly i need to export data to multiple worksheets. it is very urgent to
us.

i have a sample code which works only exporting to single worksheet. but i
need to export data to multiple worksheets.

it is very urgent to us. so please help me in code.

thanks

Regards
gaffar.

Jul 22 '05 #1
3 2374
"sridevi" <sr*****@nannacomputers.com> wrote in message
news:#o**************@TK2MSFTNGP09.phx.gbl...
Hello

How to export data from ms-access database to excel worksheet using ASP.
mainly i need to export data to multiple worksheets. it is very urgent to
us.

i have a sample code which works only exporting to single worksheet. but i
need to export data to multiple worksheets.

it is very urgent to us. so please help me in code.

thanks

Regards
gaffar.


Huh?

You state that you want to
"export data from ms-access database to excel "
but then you state that the code you have is
"exporting to single worksheet".

Where would be the source of multiple worksheets?
What are you trying to do; perhaps:

1) Export MS-Access into MS-Excel with one table per worksheet or

2) Export MS-Excel worksheets into one or more MS-Access tables?
You might want to show us what you have so far.
Jul 22 '05 #2
"sridevi" <sr*****@nannacomputers.com> wrote in message
news:#o**************@TK2MSFTNGP09.phx.gbl...
Hello

How to export data from ms-access database to excel worksheet using ASP.
mainly i need to export data to multiple worksheets. it is very urgent to
us.

i have a sample code which works only exporting to single worksheet. but i
need to export data to multiple worksheets.

it is very urgent to us. so please help me in code.

thanks

Regards
gaffar.


A little impatient aren't we! You have posted virtually the same question
three times in less than five hours using three different subject and two
different names.
Jul 22 '05 #3
Hi sir,

we are very sorry for posting the same doubt multiple number of times.
thanks for your reply,

but what we want is :

Export MS-Access into MS-Excel in such a way that each " one workbook must
be capable of holding multiple worksheets, wheer each worksheet has to be
populated from "multiple tables" of a database. by using the ASP.

we have the code for" exporting data to a single workseet "
here we are placing the code
------------------------------------
<%@ Language=VBScript %>
<%Response.Buffer=true%>
<%
Response.ContentType = "application/vnd.ms-excel"
%>

<HTML xmlns:x="urn:schemas-microsoft-com:office:excel">
<HEAD>
<style>
<!--table
@page
{mso-header-data:"&CMultiplication Table\000ADate\: &D\000APage &P";
mso-page-orientation:landscape;}
br
{mso-data-placement:same-cell;}

-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sample Workbook</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
</x:Print>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sample Workbook 2</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
</x:Print>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml><![endif]-->
</HEAD>
<BODY>
<TABLE>
<TR>
<TD>1</TD>
<TD>2</TD>
<TD>3</TD>
</TR>
<TR>
<TD>4</TD>
<TD>5</TD>
<TD>6</TD>
</TR>
<TR>
<TD>7</TD>
<TD>8</TD>
<TD>9</TD>
</TR>
</TABLE>
<TABLE>
<TR>
<TD>10</TD>
<TD>11</TD>
<TD>12</TD>
</TR>
<TR>
<TD>13</TD>
<TD>14</TD>
<TD>15</TD>
</TR>
<TR>
<TD>16</TD>
<TD>17</TD>
<TD>18</TD>
</TR>
</TABLE>

</BODY>
</HTML>

the above code is for exporting to
a single worksheet how to export to multiple worksheets

we want to export the data dynamically to multiple worksheets .


"McKirahan" <Ne**@McKirahan.com> wrote in message
news:3p********************@comcast.com...
"sridevi" <sr*****@nannacomputers.com> wrote in message
news:#o**************@TK2MSFTNGP09.phx.gbl...
Hello

How to export data from ms-access database to excel worksheet using ASP.
mainly i need to export data to multiple worksheets. it is very urgent to us.

i have a sample code which works only exporting to single worksheet. but i need to export data to multiple worksheets.

it is very urgent to us. so please help me in code.

thanks

Regards
gaffar.


Huh?

You state that you want to
"export data from ms-access database to excel "
but then you state that the code you have is
"exporting to single worksheet".

Where would be the source of multiple worksheets?
What are you trying to do; perhaps:

1) Export MS-Access into MS-Excel with one table per worksheet or

2) Export MS-Excel worksheets into one or more MS-Access tables?
You might want to show us what you have so far.

Jul 22 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Wing | last post by:
Hi, What data format can MS SQL Server 2000 export?? Wing
1
by: peteyjr | last post by:
Hi I have a asp page with a database connection where I need to export adresses into a MS Word Serial Letter. Is this possible and if how?? Any help is well appreciated Peter
1
by: Odd Bjørn Andersen | last post by:
When exporting character data with column length greater than 254, the data is truncated. For some reason I have to export the data in DEL format. Is there a way to avoid the truncation of data ? ...
0
by: abhishek.srivastav | last post by:
Hi I m a new one in Db2 .I have a table which includes a varchar,date and a clob column.I am trying to export all the columns at one go rather than exporting the varchar and date type data once...
5
by: mik18 | last post by:
I'm having trouble with exporting reports to Word in the rtf format and I'm hoping someone has a solution. The reports are losing their formats. Not all the formating is lost but some is and of...
1
by: peteyjr | last post by:
Hi I have a asp.net page with a database connection where I need to export adresses into a MS Word Serial Letter. Is this possible and if how?? Any help is well appreciated Peter
3
by: gowens | last post by:
I have an ASP.Net multi-part tabbed page. One of the tab pages contains several controls (including a DataList). The DataList contains, virtually-rendered, Database images and some text fields....
6
by: sara | last post by:
I have what I think is a little strange...I have to get data from our payroll system into a specific format (fixed record length) as a .txt or .prn file only to upload to our 401k custodian. I...
2
by: Levi Campbell | last post by:
Is there a way to export a record from a database kept with bsddb to MS Word, possibly with some type of formatting data?
1
by: danieljb1980 | last post by:
I have a problem that seems to have no easy answer, and I'm hoping someone can help me. I have an web application which is a highly customizeable export utility which I'm supposed to "enhance" to...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.