Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Lookup from Access in Excel
Name: confused725 Date: April 25, 2005 at 08:18:41 Pacific OS: Win98 CPU/Ram: 1.3/512MB
Comment:
I have a an excel spreadsheet and an access database. I need to take some specific data from access to excel. Normally I would import the data into excel and do a lookup into my other spreadsheet. However, the database has too many records to import into a single excel sheet as it contains more than 64000 rows.
Is there a way i can do a lookup directly from access to excel?
Summary: Hi there how do I put data from Access into Excel and then make a graph out of it? Also how do I put all the info from both Access and Excel into a Word document and have it automatically update when...
Summary: Hi, Is it possible to just lookup an Access database from within an Excel sheet to see if the value is there? eg. I have a list in Excel of accounts, and a database with some of those accounts. How, f...
Summary: I am trying to send some text from an Accss db to an Excel spreadsheet using DDE. Access is the client and Excel is the server. My problem is knowing the correct syntax for the DDEPoke statement, in p...