Link Excel to Access

  • Thread starter Thread starter Reggie
  • Start date Start date
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.
 
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
 
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.

--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Link Excel to Access 3
Vlookup Error Message - Excel 2003 8
Convert VLOOKUP to absolute cell reference 2
Opening excel 2010 spreadsheet from Access 4
Format appears stuck..how to break formatting 2
Linking to Access data 1
How do I set up an Excel file to be imported into Access 1

Back
Top