All Questions
3 questions
3
votes
1
answer
148
views
Running SQL Queries On A Worksheet (With Set Of Random Numbers Between 1-20 Filling Column A) Handled As An ADO
INTRO
I am using an Excel worksheet as my "database." No headers so [F1] is assigned to column one by default. I filled the entire column, all 1,048,576 ...
- 525
0
votes
1
answer
1k
views
Excel VBA Filtering: AODB vs Autofilter vs SQLite
I have an Excel sheet with data in about 100,000 rows, 16 columns. I have to extract data (one value from the 1 row I find) from this table a few thousand times. I have been using Autofilter to ...
- 1
5
votes
2
answers
1k
views
Code which pulls from SQL and dumps in Excel
I have a working code that pulls data from SQL and dumps in a column. Unfortunately it is extremely slow as it takes around half a second to pull each data point and it needs to be much faster. Are ...
- 53