Yeah, I get it; I do something similar each week at work.
This is what I've done.
1. Create a simple query that shows all of your fields in your access
table, name that query something like: qryExport.
2. Open up your excel file, create a new sheet called something like:
ImportData
3. While in your ImportData sheet, Select Data>Import External
Data>Import Data
4. At this point you should be in the MS wizard, navigate to and
select your Access file, select ok, ok, select your export query
(i.e., qryExport) from the list provided by the wizard, select ok
5. Now go back to the original sheet in your workbook that has
something like animal B
6. In the cell to the right of Animal B type in the following formula:
=VLookup(Lookup Value, Table Array, Column Index, Optional
parameter)
Where lookup value is the cell containing "Animal B" (note: do not
type the word, but rather refer to the cell - e.g., A1)
Table Array is the entire listing of items in the ImportData sheet
Column index is the column in the table array containing "horse",
probably should be "3"
Optional parameter is "False" usually
All of this can be found in MS Excel help under the Vlookup
function
7. Drag / copy the formula down to all of the necessary cells
8. Ur done.
Hope this helps, or at least gets you started; its pretty easy to do
if you take the time to read the help screens.
Kelii
This is what I've done.
1. Create a simple query that shows all of your fields in your access
table, name that query something like: qryExport.
2. Open up your excel file, create a new sheet called something like:
ImportData
3. While in your ImportData sheet, Select Data>Import External
Data>Import Data
4. At this point you should be in the MS wizard, navigate to and
select your Access file, select ok, ok, select your export query
(i.e., qryExport) from the list provided by the wizard, select ok
5. Now go back to the original sheet in your workbook that has
something like animal B
6. In the cell to the right of Animal B type in the following formula:
=VLookup(Lookup Value, Table Array, Column Index, Optional
parameter)
Where lookup value is the cell containing "Animal B" (note: do not
type the word, but rather refer to the cell - e.g., A1)
Table Array is the entire listing of items in the ImportData sheet
Column index is the column in the table array containing "horse",
probably should be "3"
Optional parameter is "False" usually
All of this can be found in MS Excel help under the Vlookup
function
7. Drag / copy the formula down to all of the necessary cells
8. Ur done.
Hope this helps, or at least gets you started; its pretty easy to do
if you take the time to read the help screens.
Kelii