Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 12th, 2009, 09:38 AM
Registered User
 
Join Date: Oct 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access & Excel

I have a webpage/site that i need to write for work... I need to query and cross reference information on an access 03 dbase with info from an excel 03 sheet. I am limited to using asp/php as the webserver is pretty old.

I was advised to use vbs for getting the information from an .xls file....

just wondering if anyone has advice on what I should use and/or link to where to get info?

Any help would be much appreciated thanks...
 
Old October 12th, 2009, 03:42 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Look here:
http://www.carlprothman.net/Default....orMicrosoftJet

That shows you the various ways to connect to an Access DB. And if you just scroll down a little ways you'll see the part titled "You can also open an Excel Spreadsheet using the JET OLE DB Provider".

Finally, you can actually reference Excel data *INSIDE* a query of an Access DB. But let's not get into that unless you need it.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 & Access Database Link KennethMungwira Excel VBA 0 October 22nd, 2007 08:26 AM
Excel 2002 Sp1 & Excel Sp2 anup.bihani Excel VBA 0 November 23rd, 2006 04:48 AM
Converting excel data to Access using excel VBA ShaileshShinde VB Databases Basics 1 April 26th, 2006 07:57 AM
Linux & KDE & C++ & QT & MYSQL & Kdevelop Munnnki Linux 0 January 2nd, 2005 05:41 PM
JOOLE & Excel ken1978 Javascript How-To 4 July 26th, 2004 06:07 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.