Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting data from ms-access database to multiple worksheets using ASP
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Excel Worksheets from Access Database | Excel Discussion (Misc queries) | |||
EXPORTING data from spreadsheet to SQL SERVER DATABASE | Excel Programming | |||
Exporting multiple worksheets as CSV | Excel Programming | |||
Exporting Access data to different worksheets on the same workbook | Excel Programming | |||
Exporting data directly from Excel to an un-opened Access database using VBA | Excel Programming |