sql - Search Results - Excel Help Forum

SQL String in Excel VBA

Started by KML1976‎, 08-04-2016 09:39 AM

6

777

Last Post By:: Last Post: 08-11-2016 07:29 AM; by LordLoki

Forum:
Excel Programming / VBA / Macros

My addin ActiveTables

Started by PowerBoy‎, 07-26-2016 06:22 AM

0

772

Last Post By:: Last Post: 07-26-2016 06:22 AM; by PowerBoy

Forum:
Access Tables & Databases

External Data Source - Limiting Columns through command text

Started by excelhelpguru‎, 07-19-2016 11:11 AM

command text, data source, external data, sql

0

612

Last Post By:: Last Post: 07-19-2016 11:11 AM; by excelhelpguru

Forum:
Excel Programming / VBA / Macros

Changing A Line in Existing Command Text for SQL Connection

Started by gedwards913‎, 07-15-2016 03:32 PM

command text, paramaters, replace, sql, vba

4

688

Last Post By:: Last Post: 07-16-2016 10:20 AM; by gedwards913

Forum:
Excel Programming / VBA / Macros

SQL Pivot function with a text file database within Excel

Started by krz‎, 07-15-2016 11:49 AM

2

619

Last Post By:: Last Post: 07-19-2016 07:17 AM; by xlnitwit

Forum:
Excel Programming / VBA / Macros

SQL Excel statement for External Data from multiple tables

Started by excelhelpguru‎, 07-12-2016 11:26 AM

external connections, external data, external database, query, sql

5

621

Last Post By:: Last Post: 07-12-2016 03:18 PM; by xlnitwit

Forum:
Excel Programming / VBA / Macros

How to change this macro to include 6 columns of data instead of 3 :)

Started by philipzack‎, 05-31-2016 05:32 AM

12

1,155

Last Post By:: Last Post: 05-31-2016 12:25 PM; by Norie

Forum:
Excel General

Aggregate error

Started by giscosta_br‎, 05-24-2016 06:24 AM

1

729

Last Post By:: Last Post: 05-24-2016 07:46 AM; by Ochimus

Forum:
Excel General

SQL Query loading in MS Query but not importing data to excel

Started by sharper1989‎, 05-19-2016 09:43 AM

1

1,080

Last Post By:: Last Post: 05-20-2016 09:52 AM; by dflak

Forum:
Excel Programming / VBA / Macros

[SOLVED] SQL Query loading in MS Query but not importing data to excel

Started by sharper1989‎, 05-19-2016 09:31 AM

0

825

Last Post By:: Last Post: 05-19-2016 09:31 AM; by sharper1989

Forum:
Access Tables & Databases

Suggestion required to work on MS access or SQL and then present the data in Excel

Started by vbvba‎, 04-21-2016 08:27 AM

1

691

Last Post By:: Last Post: 04-21-2016 08:36 AM; by grimes0332

Forum:
Access Tables & Databases

Excel VBA Querying SQL Server including Sheet Cell Reference in Query

Started by schs4‎, 04-01-2016 01:09 PM

1

445

Last Post By:: Last Post: 04-01-2016 01:31 PM; by buran

Forum:
Excel Programming / VBA / Macros

Refreshing Data Query During VBA Macro

Started by goodguygreg‎, 03-29-2016 12:30 PM

1

510

Last Post By:: Last Post: 03-30-2016 09:50 AM; by dflak

Forum:
Excel Programming / VBA / Macros

Refreshing Data Query During VBA Macro

Started by goodguygreg‎, 03-29-2016 01:05 AM

external connections, query, refresh, sql, vba

1

877

Last Post By:: Last Post: 03-29-2016 04:39 PM; by dflak

Forum:
Excel Programming / VBA / Macros

Add columns with 'local' data in an SQL linked table

Started by Samuel_j‎, 03-21-2016 02:39 AM

1

919

Last Post By:: Last Post: 03-21-2016 03:14 AM; by Samuel_j

Forum:
Excel Charting & Pivots

SQL Server Management Studio + MS Excel/Access Files?

Started by mc84excel‎, 03-16-2016 06:51 PM

5

1,631

Last Post By:: Last Post: 03-23-2016 06:24 PM; by mc84excel

Forum:
Access Tables & Databases

[SOLVED] Excel/SQL Hybrid - Run-time Error: Data type mismatch in criteria expression

Started by Sleepyshy‎, 03-11-2016 12:38 PM

1

1,066

Last Post By:: Last Post: 03-11-2016 05:43 PM; by Sleepyshy

Forum:
Excel Programming / VBA / Macros

Median multiple criteria vba

Started by serir2‎, 02-23-2016 07:55 AM

0

1,146

Last Post By:: Last Post: 02-23-2016 07:55 AM; by serir2

Forum:
Excel Programming / VBA / Macros

SQL in VBA - Concatenating 2 fields

Started by KML1976‎, 02-03-2016 12:52 PM

18

1,958

Last Post By:: Last Post: 02-05-2016 12:57 AM; by gbeats101

Forum:
Excel Programming / VBA / Macros

Loop Through Rows in VBA to import into SQL

Started by shopholic12‎, 11-24-2015 01:23 PM

1

1,014

Last Post By:: Last Post: 11-27-2015 03:48 PM; by Tinbendr

Forum:
Excel General

When I CopyFromRecordset a MYSQL CONCAT statement, it puts 256 blank rows into Excel table

Started by Coastal_view‎, 11-11-2015 09:17 AM

1

1,224

Last Post By:: Last Post: 11-11-2015 09:28 AM; by Coastal_view

Forum:
Excel Programming / VBA / Macros

[SOLVED] Run SQL queries on 2d variant arrays

Started by mc84excel‎, 09-23-2015 08:01 PM

10

3,880

Last Post By:: Last Post: 10-07-2021 06:55 AM; by AliGW

Forum:
Excel Programming / VBA / Macros

Excel Addins Data Mining

Started by ExceLLemon‎, 09-18-2015 01:39 PM

0

825

Last Post By:: Last Post: 09-18-2015 01:39 PM; by ExceLLemon

Forum:
Excel Programming / VBA / Macros

MS Query

Started by cantagallo‎, 09-14-2015 04:20 AM

0

623

Last Post By:: Last Post: 09-14-2015 04:20 AM; by cantagallo

Forum:
Excel General

[SOLVED] Comparing Variant Array to ADODB.Recordset?

Started by mc84excel‎, 09-10-2015 07:56 PM

2

1,130

Last Post By:: Last Post: 09-14-2015 07:29 PM; by mc84excel

Forum:
Access Tables & Databases

CHALLENGE: MySQL, SQL, Excel Queries to My Book

Started by ELeGault‎, 08-28-2015 07:50 PM

5

760

Last Post By:: Last Post: 08-31-2015 11:48 PM; by NeedForExcel

Forum:
Excel Programming / VBA / Macros

Error in VBA Excel-SQL coding as “Application-defined or object-defined error”

Started by cercig‎, 08-24-2015 09:34 AM

3

715

Last Post By:: Last Post: 08-24-2015 09:54 AM; by Norie

Forum:
Excel Programming / VBA / Macros

[SOLVED] Syntax error (missing operator) when UPDATE in ODBC SQL

Started by mc84excel‎, 07-01-2015 11:19 PM

8

1,750

Last Post By:: Last Post: 07-05-2015 07:40 PM; by mc84excel

Forum:
Access Tables & Databases

Incorporate SQL Query into Macro

Started by lynnexcel‎, 06-08-2015 11:46 AM

1

628

Last Post By:: Last Post: 06-08-2015 12:54 PM; by Arkadi

Forum:
Excel Programming / VBA / Macros

Management structure VBA and SQL

Started by Laik2013‎, 05-20-2015 02:28 AM

15

1,105

Last Post By:: Last Post: 05-20-2015 09:39 AM; by Laik2013

Forum:
Excel Programming / VBA / Macros

Finding all possible combinations of multiple columns separated by delimiter

Started by masuka9‎, 04-28-2015 09:08 PM

0

759

Last Post By:: Last Post: 04-28-2015 09:08 PM; by masuka9

Forum:
Excel Programming / VBA / Macros

Duplicate Pivot Cache From SQL Connections

Started by rbirch‎, 04-20-2015 08:17 PM

1

641

Last Post By:: Last Post: 05-07-2015 02:52 PM; by rbirch

Forum:
Excel Programming / VBA / Macros

SQL tables to Excel

Started by jcmckeon‎, 04-09-2015 02:28 PM

5

564

Last Post By:: Last Post: 04-09-2015 04:04 PM; by pjwhitfield

Forum:
Excel Programming / VBA / Macros

I've created an Excel plugin for using SQL inside Excel

Started by anakic‎, 04-08-2015 03:18 PM

9

1,363

Last Post By:: Last Post: 07-02-2015 09:12 AM; by anakic

Forum:
Excel Programming / VBA / Macros

So I've created an Excel plugin for using SQL inside Excel

Started by anakic‎, 04-08-2015 02:55 PM

2

432

Last Post By:: Last Post: 04-08-2015 03:09 PM; by anakic

Forum:
Hello..Introduce yourself

Search:

Search: Replies Views Search took 0.00 seconds.

SQL String in Excel VBA

My addin ActiveTables

External Data Source - Limiting Columns through command text

Changing A Line in Existing Command Text for SQL Connection

SQL Pivot function with a text file database within Excel

SQL Excel statement for External Data from multiple tables

How to change this macro to include 6 columns of data instead of 3 :)

Aggregate error

SQL Query loading in MS Query but not importing data to excel

[SOLVED] SQL Query loading in MS Query but not importing data to excel

Suggestion required to work on MS access or SQL and then present the data in Excel

Excel VBA Querying SQL Server including Sheet Cell Reference in Query

Refreshing Data Query During VBA Macro

Refreshing Data Query During VBA Macro

Add columns with 'local' data in an SQL linked table

SQL Server Management Studio + MS Excel/Access Files?

[SOLVED] Excel/SQL Hybrid - Run-time Error: Data type mismatch in criteria expression

Median multiple criteria vba

SQL in VBA - Concatenating 2 fields

Loop Through Rows in VBA to import into SQL

When I CopyFromRecordset a MYSQL CONCAT statement, it puts 256 blank rows into Excel table

[SOLVED] Run SQL queries on 2d variant arrays

Excel Addins Data Mining

MS Query

[SOLVED] Comparing Variant Array to ADODB.Recordset?

CHALLENGE: MySQL, SQL, Excel Queries to My Book

Error in VBA Excel-SQL coding as “Application-defined or object-defined error”

[SOLVED] Syntax error (missing operator) when UPDATE in ODBC SQL

Incorporate SQL Query into Macro

Management structure VBA and SQL

Finding all possible combinations of multiple columns separated by delimiter

Duplicate Pivot Cache From SQL Connections

SQL tables to Excel

I've created an Excel plugin for using SQL inside Excel

So I've created an Excel plugin for using SQL inside Excel