|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: transfer the data to an Excel Form |
|
From: |
Ajai VT |
|
Date: |
4/30/2001 8:28:22 AM |
|
IP: |
202.9.166.69 |
Set up a DSN for your excel file also. Then try this out
<%
set Conn_database =Server.CreateObject("ADODB.Connection")
set Conn_excel= Server.CreateObject("ADODB.Connection")
set RS=Server.CreateObject("ADODB.Recordset")
Conn_database.open "your database DSN"
Conn_excel.open "your excel DSN"
sql_excel = "select * from [directry$]"
set RS = Conn_excel.execute(sql)
do while loop
sql_ins = "insert into table_name values(RS("first_name"), etc"
Conn_database.execute(sql_ins)
loop
%>
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
