ExcelBanter - View Single Post - Exporting data from ms-access database to multiple worksheets using ASP

sridevi

Hi sir,

i want to Export MS-Access into MS-Excel in such a way that " one workbook
must
be capable of holding multiple worksheets, where 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:NameSample Workbook</x:Name
<x:WorksheetOptions
<x:Print
<x:ValidPrinterInfo/
</x:Print
</x:WorksheetOptions
</x:ExcelWorksheet
<x:ExcelWorksheet
<x:NameSample 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
<TD1</TD
<TD2</TD
<TD3</TD
</TR
<TR
<TD4</TD
<TD5</TD
<TD6</TD
</TR
<TR
<TD7</TD
<TD8</TD
<TD9</TD
</TR
</TABLE
<TABLE
<TR
<TD10</TD
<TD11</TD
<TD12</TD
</TR
<TR
<TD13</TD
<TD14</TD
<TD15</TD
</TR
<TR
<TD16</TD
<TD17</TD
<TD18</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 .