Excel Data Using ADO From ASP
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=10943
Printed Date: 31 March 2026 at 8:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Excel Data Using ADO From ASP
Posted By: FLATLINE
Subject: Excel Data Using ADO From ASP
Date Posted: 21 June 2004 at 6:09am
|
First, please refer to this page if you don't know what I'm talking about: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q195/9/51.asp&NoWebContent=1 - http://support.microsoft.com/default.aspx?scid=http://suppor t.microsoft.com:80/support/kb/articles/Q195/9/51.asp&NoW ebContent=1 Ok so, I got a headache from that article so I don't really know how to use that thing. What I need is a page in ASP that queries an Excel data file and imports all the data into an existing Access mdb file. Also, I need to consider the possibility that most records will already exist in the mdb file so I just want to update those according to what's in the Excel file. But new entries should be considered as well. Any ideas? ------------- Visit my site: http://darkgreen.service-club.net - DarkGreen HQ 
|
Replies:
Posted By: ljamal
Date Posted: 21 June 2004 at 8:42am
|
Why not just export the Excel document to a comma delineated text file and read in the information from there? ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: dpyers
Date Posted: 21 June 2004 at 10:01am
|
Ypu can use the Jet engine used by MS Access to treat the spreadsheet just like any other DB (except you can't delete rows). This article provides a decent overview of what you'd have to do The examples are for asp.net, but the priciples, and how you set up the connection string and the select statements are the same for asp. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: FLATLINE
Date Posted: 21 June 2004 at 10:56am
Sounds good (and simple) enough, thanks  ------------- Visit my site: http://darkgreen.service-club.net - DarkGreen HQ
|