Export ms-access tables information to excel using ASP Code

[Gaffar]

Hello,

how to export ms-access tables information to excel sheet using ASP. please
give sample code.

it is very urgent to me or if u have no idea please give any news group to
solve my question's answer.

Thanks in advance.
Gaffar.

[Ray Costanzo [MVP]]

Dim oADO : Set oADO = CreateObject("ADODB.Connection")
oADO.Open "your connection string"
Set oRS = oADO.Execute("SELECT stuff FROM table")
If Not oRS.EOF Then sCSV = oRS.GetString(,,",",vbCrLf)
oRS.Close : Set oRS = Nothing
oADO.Close : Set oADO = Nothing

Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFile = oFSO.CreateTextFile("C:\Path\file.csv")
oFile.Write sCSV
oFile.Close : Set oFile = Nothing
Set oFSO = Nothing

Ray at work

"Gaffar" <ga****@nannacomputers.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hello,

how to export ms-access tables information to excel sheet using ASP. please give sample code.

it is very urgent to me or if u have no idea please give any news group to
solve my question's answer.

Thanks in advance.
Gaffar.

[sridevi]

Hello
good morning thanks for your reply. the code which you have sent is working
for a single worksheet. but our requirement is to export the datat to
multiple worksheets.
Please help the code. waiting for your reply.

Regards
gaffar & sreedevi

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:ex**************@tk2msftngp13.phx.gbl...

Dim oADO : Set oADO = CreateObject("ADODB.Connection")
oADO.Open "your connection string"
Set oRS = oADO.Execute("SELECT stuff FROM table")
If Not oRS.EOF Then sCSV = oRS.GetString(,,",",vbCrLf)
oRS.Close : Set oRS = Nothing
oADO.Close : Set oADO = Nothing

Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFile = oFSO.CreateTextFile("C:\Path\file.csv")
oFile.Write sCSV
oFile.Close : Set oFile = Nothing
Set oFSO = Nothing

Ray at work

"Gaffar" <ga****@nannacomputers.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hello,

how to export ms-access tables information to excel sheet using ASP.

please

give sample code.

it is very urgent to me or if u have no idea please give any news group to solve my question's answer.

Thanks in advance.
Gaffar.

[Ray Costanzo [MVP]]

I think you should look into using a technology that is not ASP then. Excel
automation. Have Excel import data from a database. See
microsoft.public.excel.programming, for example.

Ray at work

"sridevi" <sr*****@nannacomputers.com> wrote in message
news:eF**************@TK2MSFTNGP14.phx.gbl...

Hello
good morning thanks for your reply. the code which you have sent is working for a single worksheet. but our requirement is to export the datat to
multiple worksheets.
Please help the code. waiting for your reply.

Regards
gaffar & sreedevi

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:ex**************@tk2msftngp13.phx.gbl...

Dim oADO : Set oADO = CreateObject("ADODB.Connection")
oADO.Open "your connection string"
Set oRS = oADO.Execute("SELECT stuff FROM table")
If Not oRS.EOF Then sCSV = oRS.GetString(,,",",vbCrLf)
oRS.Close : Set oRS = Nothing
oADO.Close : Set oADO = Nothing

Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFile = oFSO.CreateTextFile("C:\Path\file.csv")
oFile.Write sCSV
oFile.Close : Set oFile = Nothing
Set oFSO = Nothing

Ray at work

"Gaffar" <ga****@nannacomputers.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hello,

how to export ms-access tables information to excel sheet using ASP. please

give sample code.

it is very urgent to me or if u have no idea please give any news

group to solve my question's answer.

Thanks in advance.
Gaffar.