retrieving data access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Retrieving Data from Access

Retrieving Data from Access

resolvedResolved · Medium Priority · Version 2003

Steven has attended:
Excel Advanced course

Retrieving Data from Access

Is it possible to retrieve data from Access Databases using multiple entries from the same data column? e.g. I have a data table containing a list of part codes and RRPs and Descriptions for those part codes. I want to be able to enter a list of part codes into a column in Excel and retrieve the relevent RRPs and Descriptions from the Access Database.


 

Excel tip:

Finding your worksheets quickly

The arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook.

View all Excel hints and tips


Server loaded in 0.08 secs.