473,549 Members | 2,617 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 21 '05 #1
3 9229
"sridevi" <sr*****@nannac omputers.com> wrote in message
news:#o******** ******@TK2MSFTN GP09.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
"sridevi" <sr*****@nannac omputers.com> wrote in message
news:#o******** ******@TK2MSFTN GP09.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
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=VBScri pt %>
<%Response.Buff er=true%>
<%
Response.Conten tType = "applicatio n/vnd.ms-excel"
%>

<HTML xmlns:x="urn:sc hemas-microsoft-com:office:exce l">
<HEAD>
<style>
<!--table
@page
{mso-header-data:"&CMultipl ication Table\000ADate\ : &D\000APage &P";
mso-page-orientation:lan dscape;}
br
{mso-data-placement:same-cell;}

-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkboo k>
<x:ExcelWorkshe ets>
<x:ExcelWorkshe et>
<x:Name>Sampl e Workbook</x:Name>
<x:WorksheetOpt ions>
<x:Print>
<x:ValidPrinter Info/>
</x:Print>
</x:WorksheetOpti ons>
</x:ExcelWorkshee t>
<x:ExcelWorkshe et>
<x:Name>Sampl e Workbook 2</x:Name>
<x:WorksheetOpt ions>
<x:Print>
<x:ValidPrinter Info/>
</x:Print>
</x:WorksheetOpti ons>
</x:ExcelWorkshee t>
</x:ExcelWorkshee ts>
</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******** ************@co mcast.com...
"sridevi" <sr*****@nannac omputers.com> wrote in message
news:#o******** ******@TK2MSFTN GP09.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1876
by: Wing | last post by:
Hi, What data format can MS SQL Server 2000 export?? Wing
1
2101
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
2446
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 ? -- Regards ----------- Odd Bjørn Andersen ErgoSolutions AS
0
1363
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 and then the clob data . When doing this i;e exporting all the columns at one go,I m getting the flat file of size Zero .No error is showing up in the...
5
3040
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 course it's the really important parts that are lost. In one report the grouping is lost and everything gets repeated. I've created several reports...
1
2122
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
3831
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. We'd like to take the content and format of the DataList to create a Word document (album) for the end-users. Is it possible to export the DataList...
6
8187
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 can get the data into Access (from Payroll) and write a query with all the fields (inserting fields with spaces, as needed), but I can't figure out...
2
1644
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
2569
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 give a slightly new functionality. Currently the user has the option of exporting their templated data to xml. This current export just simply...
0
7541
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7464
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7979
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7826
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6065
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5385
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3512
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1960
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1074
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.