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

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
As far as I can determine, it is not possible to index a linked Excel file, so I guess that's not an option.

ξ
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,217,500
Messages
6,137,006
Members
450,038
Latest member
JackOfBlades

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
Back
Top