J
Jack
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
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