Access / excel question

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841
I am linking a file to access so that I can use SQL to pull into another Excel File. I was hoping this would be quicker than person who was doing a massixe amount of Vlookups.
Is there a way I can Index (Speed up) the link or can this only be done with a access file not a link?
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,836
Office Version
  1. 2019
Platform
  1. Windows
As far as I can determine, it is not possible to index a linked Excel file, so I guess that's not an option.

ξ
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,343
Office Version
  1. 365
Platform
  1. Windows
Why do you need to link the Excel file to Access to use SQL?

Have you considered using ADO to get the data directly from the Excel file?
 

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841
I was going to pull some other info that I already had in access. And more importantly just rtrying to build a tool that person can use to reallly basically do vlookups but the darn files are so big that I thought it might be easier.
 

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,836
Office Version
  1. 2019
Platform
  1. Windows
Don't know if it matters but having the other file open - if its a completely different workbook that's the lookup source - helps. Lookups on closed workbooks with thousands of rows can be slow.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,686
Messages
5,833,109
Members
430,194
Latest member
dbow2226

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top