VLookup to merge Access Query data into Excel Report

VLookup to merge Access Query data into Excel Report

Post by VmlyYS1TSk » Thu, 12 Jan 2006 04:18:02


Bernie,

You mentioned to Bum that you had some code to merge Access Query Data into
specific cells in Excel. Can you send me that code as well.

I would greatly appreciate it.

Vira-SJH
 
 
 

1. Word Mail Merge w/Access Data Base - reports empty data base recor

2. Macro to check data from excel list against access query and return value back to excel

(I posted this yesterday but am tryign to make it clearer)
I have an excel list with "name" and "title" and there are many erros
and mis-spellings. I havbe an acess quesry that has the correct names
and titles and also some mis-spellings and foreign language spellings
pointing to the correct english name and title.

I would like to write a macro in excel to do a lookup of the excel
value in the access quesry and find EITHER an exact match or close
match and return the value of a specified field back into an excel
column.

Here is a hypothetic example:
Access list:
PK=Van Gogh, Vincent
vangogh
VanGogh
Van Go

PK= Starry night, c1889
starrie night
starry nite
french for starry night

Excel list
vangogh
starry nite

I want to do a look up in access. from excel. of both the name and the
name combined with the title and return the correct value back into
excel in a blank column:
lookup:
vangogh
vangogh, starry nite

return:
Van Gogh, Vincent
Starry Night, 1889

I can do a look up that wil return a close match but do not knwo how
to do a look up of combined fields liek name and title to search
access name and title and return a single value. PLus try to write a
macro to do it.

I am stumped.

3. Using VLookup to Import Data from Access to Excel

4. Report based on Query - Query displays correct data, but the report does not...

5. Data too large for Excel, need to query Access data for results

6. Excel data merging across excel files and matching field data

7. Using Excel data to create mail merge/report

8. Word 2003 Merge won't show data in Access Query?

9. Merging Query Data from Access to Word.

10. Mail merge macro not adding MS Access query data to form

11. Unable to use Access queries as data source for a mail merge doc