| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to access database
I'm using Vlookup in Workbook 1 to find information in Workbook 2 which has
over 51000 rows in Excel 2003. The data was originaly in access linked to an oracle table. Three data fields have been concatentated to create a lookup in workbook 2. i.e. A B C D E 1 MI 48 101 MI48101 5.00 2 MI 48 201 MI48201 5.25 How can i do a direct query into access to get the information in Column E? Jack |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Excel Database via Access Main Database with a script | New Users to Excel | |||
| How do break the link from my excel workbook to a access database. | Excel Discussion (Misc queries) | |||
| Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
| Access Database | Excel Discussion (Misc queries) | |||
| Open Access Database with VBA | Excel Discussion (Misc queries) | |||
Linear Mode
