By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,948 Members | 1,975 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,948 IT Pros & Developers. It's quick & easy.

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

P: n/a
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 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"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 21 '05 #2

P: n/a
"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 21 '05 #3

P: n/a
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 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.