Retrieving Data from Access

The UK's most regular instructor-led training courses.
Training information: financial excel course london · Excel courses london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

· Medium Priority · Version 2003

Steven has attended:
Excel Advanced course

by - delegate Steven [1 post] (2008 Apr 25 Fri, 14:25) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Aug 12 Tue	Bloomsbury	0	FULL
2003/XP	2008 Aug 12 Tue	Tooting	0	FULL
2003/XP	2008 Aug 14 Thu	Southwark	0	FULL
2007	2008 Aug 19 Tue	Bloomsbury	5	book now	£212	£224
2003/XP	2008 Aug 21 Thu	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Aug 21 Thu	Bayswater	4	book now	£195	£205
Full Schedule: See all 145 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

· MS Excel: Excel At Making The Most Of Your Christmas
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Database Tips from an Excel Training Course
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· How to Create Better Excel Spreadsheets: Part One

Please browse our web site to find out more about
financial excel course london and other Microsoft training courses.

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

View all Excel hints and tips