Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Excel Data Using ADO From ASP
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Excel Data Using ADO From ASP

 Post Reply Post Reply
Author
FLATLINE View Drop Down
Groupie
Groupie
Avatar

Joined: 08 July 2002
Location: Israel
Status: Offline
Points: 142
Post Options Post Options   Thanks (0) Thanks(0)   Quote FLATLINE Quote  Post ReplyReply Direct Link To This Post Topic: Excel Data Using ADO From ASP
    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://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?
Thanks.

Visit my site: DarkGreen HQ
Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888
Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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
http://authors.aspalliance.com/wisemonk/view.aspx?id=AD06250 2-all

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.
Back to Top
FLATLINE View Drop Down
Groupie
Groupie
Avatar

Joined: 08 July 2002
Location: Israel
Status: Offline
Points: 142
Post Options Post Options   Thanks (0) Thanks(0)   Quote FLATLINE Quote  Post ReplyReply Direct Link To This Post Posted: 21 June 2004 at 10:56am
Sounds good (and simple) enough, thanks
Visit my site: DarkGreen HQ
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.