SQL [Archive] - VBA Express Forum

Accessing recordsets (3 replies)
SQL Query Optimization: Combining Multiple Joins for Improved Performance (6 replies)
TIMESTAMPDIFF from one column (SQL Server) (2 replies)
[SOLVED:] Parameterized MySQL SP as Form data input (3 replies)
SQL Server and SharePoint (1 replies)
Query for retrieving limited records (2 replies)
Unable to get view definition in vba (0 replies)
Sqlserver database multipe tables data to access database (3 replies)
[SOLVED:] Dynamic Function (1 replies)
How to union two tables without losing ordering (3 replies)
Not able to add one condition in old script (1 replies)
Where I type wrong??? (1 replies)
Sum one column and limit to the eaileir date ... (0 replies)
Solving Data Quality issues on SQL DB (0 replies)
How to use COUNT with "WHERE" (0 replies)
[SOLVED:] simple SELECT query to .mdb still fails! (0 replies)
more than one row returned by a subquery used as an expression (0 replies)
Import data from DB2 to Excel issue (0 replies)
CSV File Import (3 replies)
display above spicific day in SQL using access and vba (1 replies)
[SLEEPER:] DataAdapter (0 replies)
vba function to query oracle database (2 replies)
Delete and Insert new data if the date exists or insert data if date not exist. (0 replies)
[SOLVED:] Skip Null and Zero Values In SQL Statement (4 replies)
Exclude record if in a column (0 replies)
Challenge - Resolve this error: "ORA-00923: FROM keyword not found where expected" (3 replies)
[SLEEPER:] Replace commas as part of double quote enclosed string or convert csv 2 tab delimited (0 replies)
Check if value exists in Sql server Table with vba (0 replies)
Unable to pull individual columns get EXPR1000, EXPR1001 (0 replies)
VBA - SQL Select and return value on the same row (0 replies)
MySQL error (5 replies)
SQL Query - Design struggle (0 replies)
Help Please - Sql Query (1 replies)
Getting an error - Compile error- User defined type not defined (1 replies)
Connection to SQL Server Database using generated Data Source fails ... (1 replies)
ERROR JOIN, ACCES ,SQL... (2 replies)
Unable to fetch data from Mysql where the data type is Text (1 replies)
SQL not working for numbers but works for text, how can i make change (1 replies)
Trying to to do a Sum(MAX) calculation in SQL Server (0 replies)
VBA CopyFromRecordset won't print all collumns (1 replies)
Run-time error '3704' - Operation is not allowed when the object is closed (1 replies)
I am having a challenge trying to retrieve data using a date function in SQL. Thanks (0 replies)
How to display SQL query results (1 replies)
Issue with OLEDB Connection (0 replies)
importing an xml file into a new MS SQL Server table (0 replies)
[SOLVED:] importing an xlm file into a new MS SQL Server table (1 replies)
SQL Add 2nd Most Recent Date From Another Table (1 replies)
[SOLVED:] SQL Add a date from another table (3 replies)
Need helps with LEFT OUTER JOIN (1 replies)
VBA-SQL Server connection problem... (6 replies)
creating a mailing list using SQL Server as the database (0 replies)
Need assist with sheet naming and probably other issues as well (2 replies)
How to recover sql database (1 replies)
User Form to Insert data into SQL (1 replies)
TSQL Select Third Largest Value (7 replies)
Refresh Tables at Specified Time (0 replies)
[SOLVED:] Status Bar Display (9 replies)
[SOLVED:] Combining Results from two sql statements into one showing a new result. (1 replies)
[SOLVED:] Concantenating two columns (1 replies)
Retrieve CLOB Data Type from Oracle (0 replies)
[SOLVED:] getting total use of values across multiple columns (1 replies)
distinct rows based on combination of columns (1 replies)
SQL query with 2 differenet table (2 replies)
Datetime Parameter with date of Today or Today-1 and time set at 7am (6 replies)
SQL Query Help (If Selecting??) (2 replies)
Data in Orcale R12 need to identify (0 replies)
Problem to find the good request (0 replies)
Run-Time Error '-2147217900 (80040e14)': The Certificate, asymmetric key, or private (2 replies)
Text column holds value of ID (2 replies)
Macro button to import data from mySQL joined tables into excel based on matching ID (0 replies)
SQL Query With VBA (0 replies)
Update SSRS exported spreadsheet (1 replies)
SQL trigger run update on second table (0 replies)
[SOLVED:] Trigger to create a backup table (1 replies)
Shift Excel Cell after executing a macro (6 replies)
sql in vba - could not find a file (4 replies)
use a variable SQL column to recieve data to excel (1 replies)
Multiple DSN's for Excel Macro (1 replies)
Fay: Access_2010_Combining_an_Insert_Into_statement_with_Select. (2 replies)
Mysql query to count the records even data not exist (0 replies)
To pull data from Access to VBA on Multi selected variables from the list box (0 replies)
THE SAME COLUMN (0 replies)
Loop in SQL (1 replies)
[SOLVED:] query not working (1 replies)
VBA Wildcard (2 replies)
SQL SELECT same column different Counts (2 replies)
computer stoped being able to connect to SQL server (4 replies)
VBA process multiple files in same folder in sequential order? (0 replies)
Counting combinations using criteria from subquery (0 replies)
SQL Embedded in VBA using Queryopen (2 replies)
Getting an error in this VBA (0 replies)
How to query oracle using VBA (0 replies)
AdventureWorksDW2012 (2 replies)
VBA Code (4 replies)
VBA - SQL Syntax checker function (0 replies)
[SOLVED:] Filter DataBase Between Selected Start and End Dates w/ Visual Studio 2012 (1 replies)
[SOLVED:] Excel Formula To TSQL (1 replies)
Book (1 replies)
Emails (0 replies)
BULK INSERT Text Files into SQL/Oracle (0 replies)
only local SQL databases? (3 replies)
SQL string syntex problem (2 replies)
vba to sql (15 replies)
LocalDB installation (0 replies)
[SOLVED:] transitioning from vba/access sql to T-SQL and errors (1 replies)
Return multiple results if multiple strings (1 replies)
VBA [Excel 2007] to SQL Server [9.0] (0 replies)
Automation Error: (1 replies)
CopyFromRecordset vs. GetString() (0 replies)
Solved: Table Autonumber and Visual Studio VBA (4 replies)
creating bounded groupings (0 replies)
Solved: Visual Studio Form Control (2 replies)
VBA code to get data from Mainframe (0 replies)
SubQuery Amnesia??? (2 replies)
How to pass combobox/textbox selected member into sql string in main module (0 replies)
how to automatically update sql results in ActiveX Combobox? (7 replies)
Solved: ADO Parameter query.. from text file! (6 replies)
Doing a calculation on a derive column within an SQL statement (0 replies)
Count unique instances of a column in relation to another column? (0 replies)
Connect to oracle from excel (2 replies)
Excel Front end, SQLServer backend??? (7 replies)
Can't resolve "Query too complex" error (0 replies)
Solved: Update Query (1 replies)
Statement Help (3 replies)
Filter by previous week (2 replies)
Oracle SQL (1 replies)
creating random future dates with datediff() (1 replies)
Solved: Loop to create repeating SQL statment with incrementing variables (1 replies)
VBA ,SQL Data type (0 replies)
SQL insert (0 replies)
Present SQL result in Word??? (1 replies)
Plz help a newbie understand SQL (1 replies)
Converting A date Function from VBA to SQL (0 replies)
Urgent : How run BCP command using .bat/.vbs file from Excel VBA? (1 replies)
Can't get RecordCount of a Query Output from Oracle DB using VBA (3 replies)
Solved: Need to Store query results for use by another query (1 replies)
sql excel vba connection problem (8 replies)
Advanced SQL Sorting (0 replies)
Specified Procedure Not Found (1 replies)
ADO Connection Problems (1 replies)
VBA code to export SQL extract result and formatting (1 replies)
Database Design for Multiple Filters (5 replies)
empty recordset when multiple entires in parameter (1 replies)
Multiple JOINS without NESTING (1 replies)
Sending a SQL String to SQL Server 2008 from Excel? (0 replies)
SQL Server Database Integration with EXCEL (2 replies)
Excel to SQL Server (SqlBulkCopy method) (5 replies)
different version of versions(dialects) (4 replies)
Setting Parameters or Query def for Access 2003 DAO SQL query (2 replies)
If argument in SQL query (2 replies)
Solved: Table Design / SQL Design Advice (10 replies)
Get all results from where clause even value doestn exits. (1 replies)
Notifying Excel 2007 about changes in a database in SQL Server 2008 R2 (0 replies)
Solved: ADO error: syntax error or access violation (0 replies)
Merging into one.... (1 replies)
SQL Download (4 replies)
ListBox.Value inside an MySQL Query (4 replies)
Update Script (4 replies)
TO_NUMBER SQL function not work (2 replies)
converting Access db To SQL Server (1 replies)
Access - SQL Query to repair table. (1 replies)
Solved: Remove duplicate records (4 replies)
Sleeper: Create Subtotals (0 replies)
Best Practice Advice (3 replies)
SQl VBA Access 2007 -filter not working properly (0 replies)
Solved: How to fill all sheet name into Combo in ADO (7 replies)
SQL problem with Null (1 replies)
Solved: vba to solidDB (1 replies)
Solved: ACE.OLEDB and SELECT INTO [Excel (1 replies)
Feeding data set into a sql stored proc using VBA (1 replies)
Store Procedure that deals with nested tables? (4 replies)
ODBC connector (1 replies)
Solved: Type conversion error with SQL query (3 replies)
Access Format vs SQLS Convert (1 replies)
SQL Syntax Error (0 replies)
Quick question - Sql server (2 replies)
SQL COMMAND ISSUE (1 replies)
Batch processing SQL query strings (1 replies)
SQL Express, Access front end deployment (0 replies)
Solved: VBA-SQL Type Mismatch (3 replies)
SQL Server Export Specifications (3 replies)
Syntax to display last day of current month (0 replies)
MS Sql Reporting Services configuration problem (1 replies)
Update query in ms access (2 replies)
Solved: nested loop on sql statement (1 replies)
get list of items which are there in result of 1 query and not there in another query (2 replies)
getting value into a string using sql statement in VBA. (1 replies)
Solved: Count include 0? (4 replies)
Solved: Convert 12-hour to 24-hour (0 replies)
Solved: Specific Order? (2 replies)
SQL help, ms access (5 replies)
Solved: Help required in SQL Statement. (11 replies)
Use a stored procedure in Access 2007 .. (1 replies)
select multiple foxpro databases for query (0 replies)
access 2007 update query using CASE (2 replies)
SQl server 2000 (3 replies)
Solved: New SQL user (1 replies)
Solved: Extract data from SQL Server table into excel (9 replies)
Solved: Alter table script (1 replies)
Solved: Populate a comboxbox and Listbox in a excel userform with an sql table data (26 replies)
SQL Query in Excel VBA - Runtime Error 1004 (1 replies)
Can't create table from script (3 replies)
Odd 'Where' statements (1 replies)
SQL Server 2008 book recommendation (2 replies)
SQL and Word Connection - finding data to put into word (0 replies)
Solved: SQL Syntax for querying two tables with specific columns (1 replies)
Solved: List grid solution for a user form (8 replies)
How can i link my website to the result generated from excel (VBA) ? I have no idea ! (0 replies)
VBA Check Box (1 replies)
Solved: Using SQL to build a drop-down list (4 replies)
Querying dates fails (2 replies)
QueryTable.ResultRange includes header row (0 replies)
How to learn VBA excel with use ODBC connection SQL query (0 replies)
Field Name unknown in SQL with VBA excel (1 replies)
ODBC in SQL error (5 replies)
[SOLVED:] Installing SQL Server on a Server (1 replies)
Solved: SQL Server Express - Free Download (0 replies)
Friendly inquiry (4 replies)
[SOLVED:] Connecting to Commercial Software (2 replies)
Solved: Convert Varchar to Date format (3 replies)
SQL Relationship (2 replies)
Excel to SQL (2 replies)
Retrieve SQL Server data from remote server (0 replies)
Data import from closed workbook omits cells (0 replies)
Solved: D*MN Column Headers!!!! (3 replies)
veiw sql query for the output. (0 replies)
SQL Compare Databases (3 replies)
Concurrent Installs of MS SQL Server 2005 And MS Sql Server 2008 Express (1 replies)
Solved: SQL Server 2005 Connection Problem (1 replies)
Fun with SQL Policy Manager Exported Results (XML) (2 replies)
SQL query to retrieve only rows from 60000 to last row (6 replies)
Pivot Tables question (1 replies)
Solved: Testing current date... (3 replies)
Logparser SQL and HTTP/SOAP: redux (0 replies)
Inner Join 2 Excel Sheets with ADO? (10 replies)
Solved: Stored Procedure not executing from scheduled task? (1 replies)
Stored Proc question (5 replies)
How to call a Stored Procedure in Word (2 replies)
Solved: SP_HELP (2 replies)
Newbie - Excel data from MySql on server (4 replies)
LogParser SQL - basics++ (1 replies)
LogParser SQL - basics (14 replies)
Wildcard in SQL (2 replies)
Excel api and databases (3 replies)
Error 3001 when calling stored proc (1 replies)
SQL Enterprise Manager (View) IIF Then (1 replies)
Solved: Report From query issue (access SQL) (1 replies)
Vba Code to insert data from access table to mysql table (2 replies)
Solved: Simplify SQL (5 replies)
vba sql datetime format (3 replies)