Timeline for VBA- Retrieving data from an access database by referencing a column in excel
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 25, 2017 at 4:31 | comment | added | Tim Williams | In that case you could query the whole table and load the data into a dictionary keyed on Material. Then pull A2:A6768 into an array and loop over it, looking up each value against the dictionary and putting the result into a same-sized array which you can finally dump back on the worksheet. | |
| Sep 24, 2017 at 9:03 | comment | added | SQL_APPRENTICE | around 100k max | |
| Sep 22, 2017 at 22:46 | comment | added | Tim Williams | How many records total in the table being queried? | |
| Sep 21, 2017 at 16:25 | answer | added | Joffan | timeline score: 0 | |
| Sep 21, 2017 at 8:54 | comment | added | Toby Speight | When you say, "I am not able to run ...", do you mean that the code doesn't work in those cases? If so, it's broken, and not yet ready for review. We only consider working code here. | |
| Sep 21, 2017 at 8:51 | answer | added | this | timeline score: 1 | |
| Sep 21, 2017 at 8:34 | review | First posts | |||
| Sep 21, 2017 at 8:54 | |||||
| Sep 21, 2017 at 8:29 | history | asked | SQL_APPRENTICE | CC BY-SA 3.0 |