All Questions
19 questions
3
votes
1
answer
564
views
VBA introspection library for SQLite
SQLiteDB VBA Library is a set of VBA helper functions for the SQLite engine. The primary motivation behind this project is to provide convenient access to extended introspection features. Because of ...
- 415
3
votes
2
answers
172
views
How to get the median value faster
Using Excel, I have one sheet ("db") with data extracted from MES.
I have to analyze this data and I need: Articolo, Fase, Tipo Confezione, TURNO, Macchina, avg and median.
I searched ...
- 297
2
votes
1
answer
218
views
VB.net SQL match against Excel data to datagridview
I am importing an Excel sheet where the first column will contain product numbers. I match those numbers to my SQL database and display the product number and description of the matching products to a ...
- 23
-1
votes
1
answer
37
views
SQL Group qry by codeProduct and Last(description) [closed]
For the ADMIN: I wrote this tread on S.O. questions/61183026, but I think that is more correct to post this tread here, if you think no, please scuse me and delete this message.
Hi, I've one xls ...
- 297
3
votes
1
answer
172
views
SQL to Excel then to CSV file for Data Upload
Before we get started I need to let you know a critical piece of information: Due to permissions within an offsite database I am NOT allowed to create tables even temporary ones within the database ...
- 595
3
votes
1
answer
316
views
VBA and SQL to return SQL results to Excel
Now that I finally have time to look back at this code I wrote over a year ago. I need help with streamlining the code I have written. I had to write a significant amount of ...
- 595
0
votes
1
answer
5k
views
VBA Excel Looping through recordset and storing the data to use later
I have a loop to add Recordset items to a Dictionary so I can do comparisons and retrieve specific data later in the code (not ...
- 11
1
vote
0
answers
775
views
Running an UPDATE SQL QUERY within VBA using DAO
I have a macro in Excel that updates a recordset using WHERE a primary key in MS Access matches a primary key in a UserForm label value. The macro is called from a ...
- 41
3
votes
1
answer
164
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
2
votes
0
answers
647
views
Create and email an Excel report of data retrieved from SQL
This is my first Python (3.6) script which I would appreciate some critique of.
I am generating a daily alarm report. The data is gathered from an SQL Server database, presented in an xlsx file ...
- 21
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
0
votes
1
answer
114
views
Get data from Access SQL database with ADODB and weather data using web service and Excel VBA
This is a follow-up from this post.
It all works, but I think the code could be made to work faster and to be more stable. I have made improvements and updated the code in this new question.
...
- 153
5
votes
2
answers
765
views
Get data from Access SQL database with ADODB and weather data using web service
I have a program, that works, I just feel that it is running slower than it should and I feel that it is a bit more unstable than it should be. I am looking for tips on writing "better" code and ...
- 153
3
votes
2
answers
2k
views
C# Datagridview to Access database
I feel like there would be a better way to this. Essentially, I am transporting the data from an excel file to a DGV, and then from a DGV to an Access database. Should I cut the middle man or is this ...
- 291