Excel and/or SQL Help
For questions, discussion and knowledge sharing pertaining to the SQL Query Language (e.g. MS SQL, MySQL, Access Queries and Crystal Reports). SEARCH. Today's Last 10 Questions
-
-
-
Take Excel & Office To A Whole New Level!
- Dave Hawley
-
- Replies
- 0
- Views
- 13k
-
-
-
-
SQL Select Where Clause doesnt return any result 4
- NewbieError
-
- Replies
- 4
- Views
- 989
4
-
-
-
-
Use SQL query output to populate a Combobox in Excel 8
- Mesjefskie
-
- Replies
- 8
- Views
- 36k
8
-
-
-
-
How can I change the formula so that I can stop getting the cell blank every time the excel is open
- Vijetha
-
- Replies
- 0
- Views
- 356
-
-
-
-
SQL in VBA Excel to query multiple tables in Access database 3
- wesselsteyl
-
- Replies
- 3
- Views
- 2.4k
3
-
-
-
-
SQL Return Column values only when >1 and 1
- exvb_1
-
- Replies
- 1
- Views
- 879
1
-
-
-
-
Pushing data from Excel to SQL Server
- Rattatosk
-
- Replies
- 0
- Views
- 399
-
-
-
-
ADODB Connection referring to Local path NOT Network 4
- Ktrasler
-
- Replies
- 4
- Views
- 6.7k
4
-
-
-
-
SQL VBA in Excel - Macro Runs, SQL Works in MS Server 08 - No Data Returned 5
- css7493
-
- Replies
- 5
- Views
- 8.2k
5
-
-
-
-
Nested While loop in SQL Statement 1
- Dave Edmonds
-
- Replies
- 1
- Views
- 1.3k
1
-
-
-
-
Data type mismatch in criteria expression 2
- PeterLz
-
- Replies
- 2
- Views
- 2.5k
2
-
-
-
-
Using the IN Sql statement with many parameters causing runtime errror in VBA 4
- NBVC
-
- Replies
- 4
- Views
- 1.2k
4
-
-
-
-
Connecting to localhost MySQL Database 1
- iwrk4dedpr
-
- Replies
- 1
- Views
- 1.2k
1
-
-
-
-
Function sequence error 1
- di1ontes
-
- Replies
- 1
- Views
- 626
1
-
-
-
-
Using Microsoft Query to summarize multiple workbooks 1
- jiddings
-
- Replies
- 1
- Views
- 1.2k
1
-
-
-
-
SQL multiple counts from same column 4
- Paul51480
-
- Replies
- 4
- Views
- 957
4
-
-
-
-
Substring! HELP 1
- moraak
-
- Replies
- 1
- Views
- 1.9k
1
-
-
-
-
Merge two SQL tables 1
- tompie007
-
- Replies
- 1
- Views
- 782
1
-
-
-
-
count of patients, for specific hourly periods between start and end dates
- CBJ1969
-
- Replies
- 0
- Views
- 593
-
-
-
-
insert data from excel to mysql 1
- soul_krasty
-
- Replies
- 1
- Views
- 2.5k
1
-