Link Excel to Access

R

Reggie

I am needing to populate an excel spreadsheet with data
that is in an Access file. The problem is that the Access
records are 779,834 and the Excel spreadsheet is 44,000. I
need help in linking a VLOOKUP function to the Access file.
 
F

Frank Kabel

Hi
just as a suggestion: Why not do this linking in Access
(link the Excel table in Access) and use SQL for this.

Afterwards you may create a query in Access to return the
values back to Excel
 
J

Jamie Collins

Frank Kabel said:
Why not do this linking in Access
(link the Excel table in Access) and use SQL for this.

Afterwards you may create a query in Access to return the
values back to Excel
Click to expand...

It is more usual for a client application to pull the data it needs
from a database server, rather than get the server to push data to the
clients. I've also heard from MS Access MVPs that updating a linked
Excel table in MS Access can cause the workbook to go corrupt.

Jamie.

--
 
Top