sql - Search Results - Excel Help Forum

Excel to SQL [PostgreSQL]

Started by YRSTRULY‎, 11-13-2023 06:35 AM

3

742

Last Post By:: Last Post: 11-13-2023 10:53 AM; by 6StringJazzer

Forum:
For Other Platforms(Mac, Google Docs, Mobile OS etc)

VBA code to delete XLSX database record

Started by ajwebtv01‎, 10-19-2023 05:51 AM

7

280

Last Post By:: Last Post: 10-21-2023 05:36 AM; by TMS

Forum:
Excel Programming / VBA / Macros

ODBC Connection to SQL server

Started by btamulis‎, 07-22-2023 08:46 AM

5

523

Last Post By:: Last Post: 07-25-2023 10:18 AM; by dflak

Forum:
Excel General

[SOLVED] How to combine large datasets with calculations in Excel

Started by petocities‎, 06-20-2023 04:07 PM

data analysis, large amount of data, power bi, sql, vba

11

662

Last Post By:: Last Post: 06-23-2023 10:44 AM; by petocities

Forum:
The Water Cooler

Consolidating several columns of values to 1 - new records NOT SUM

Started by bigdatahelp‎, 01-12-2023 04:22 PM

add a row, big data, database functions, excel, sql

1

373

Last Post By:: Last Post: 01-13-2023 05:52 AM; by Glenn Kennedy

Forum:
Excel Charting & Pivots

[SOLVED] ADODB.recordset.find gives a compile error expected function or variable

Started by Leon V (AW)‎, 10-25-2022 04:26 AM

2

269

Last Post By:: Last Post: 10-25-2022 05:36 AM; by ByteMarks

Forum:
Excel Programming / VBA / Macros

[SOLVED] recordset "WHERE" failing

Started by Leon V (AW)‎, 10-13-2022 11:04 PM

4

327

Last Post By:: Last Post: 10-14-2022 02:23 AM; by Leon V (AW)

Forum:
Excel Programming / VBA / Macros

Summarize data

Started by maxmuster97‎, 10-11-2022 11:08 AM

1

1,261

Last Post By:: Last Post: 10-13-2022 12:12 AM; by alansidman

Forum:
Access Tables & Databases

[SOLVED] Code Improvement - SQL Statement Update SharePoint List

Started by teixeire‎, 06-27-2022 09:08 AM

7

317

Last Post By:: Last Post: 06-28-2022 11:34 AM; by teixeire

Forum:
Excel Programming / VBA / Macros

Excel ruins the order of columns when imported if renaming an alias of one of the columns

Started by whatever61‎, 03-29-2022 05:26 PM

1

285

Last Post By:: Last Post: 03-29-2022 07:06 PM; by whatever61

Forum:
Excel General

How to query an open ListObject?

Started by johnywhy‎, 10-02-2021 04:05 PM

5

630

Last Post By:: Last Post: 10-06-2021 03:02 PM; by johnywhy

Forum:
Excel Programming / VBA / Macros

Use dynamic file for SQL query instead of static code

Started by noxhun‎, 09-29-2021 12:58 AM

3

362

Last Post By:: Last Post: 09-29-2021 08:52 PM; by alansidman

Forum:
Excel Programming / VBA / Macros

Excel 365 VBA: Filter sql query with form

Started by pawe84‎, 07-30-2021 09:58 AM

1

350

Last Post By:: Last Post: 07-30-2021 10:36 AM; by ranman256

Forum:
Excel Programming / VBA / Macros

Getting actual date fields from a SQL refresh

Started by centuori52‎, 05-21-2021 08:37 AM

date & text formula, date formatting, sql, sql excel

0

424

Last Post By:: Last Post: 05-21-2021 08:37 AM; by centuori52

Forum:
Excel General

[SOLVED] pivot table - second record - from SQL server

Started by MartyZ‎, 04-07-2021 06:51 AM

2

544

Last Post By:: Last Post: 04-07-2021 09:34 AM; by MartyZ

Forum:
Excel Charting & Pivots

[SOLVED] Excel VBA SQL ADO Recordset Returning Old Cached Results

Started by RowanB‎, 03-03-2021 11:00 AM

13

1,255

Last Post By:: Last Post: 03-04-2021 07:22 AM; by rorya

Forum:
Excel Programming / VBA / Macros

When is Excel better than SQL?

Started by dbrown1623‎, 01-29-2021 02:42 AM

3

695

Last Post By:: Last Post: 01-29-2021 06:27 AM; by alansidman

Forum:
Excel General

Unable to find data sources in Excel spreadsheet

Started by lukedout‎, 01-21-2021 01:43 PM

1

407

Last Post By:: Last Post: 01-21-2021 01:51 PM; by AliGW

Forum:
Excel Programming / VBA / Macros

Query 4 tables so Slow

Started by atzdgreat‎, 01-12-2021 03:57 AM

0

338

Last Post By:: Last Post: 01-12-2021 03:57 AM; by atzdgreat

Forum:
Excel Programming / VBA / Macros

Acces Query in Power Query

Started by ikkezelf1944‎, 01-09-2021 09:28 AM

1

449

Last Post By:: Last Post: 01-09-2021 03:29 PM; by alansidman

Forum:
Excel Programming / VBA / Macros

[SOLVED] SQL join syntax error

Started by redmarko‎, 11-09-2020 04:34 PM

4

1,274

Last Post By:: Last Post: 11-10-2020 05:17 PM; by 6StringJazzer

Forum:
Excel Programming / VBA / Macros

WorkbookConnection.Refreshing not triggering in a while sleep(1000) loop

Started by HansSchulze‎, 05-16-2020 10:42 PM

2

448

Last Post By:: Last Post: 05-16-2020 11:22 PM; by HansSchulze

Forum:
Excel Programming / VBA / Macros

VBA Excel to UPDATE SharePoint Lists and Libraries

Started by drrichs‎, 04-08-2020 02:51 PM

0

718

Last Post By:: Last Post: 04-08-2020 02:51 PM; by drrichs

Forum:
Excel Programming / VBA / Macros

Linking Offline Data Adjacent to PivotTable Row Data

Started by halmg‎, 02-26-2020 08:12 AM

0

416

Last Post By:: Last Post: 02-26-2020 08:12 AM; by halmg

Forum:
Excel Charting & Pivots

Import Images/Pictures/Shapes from a Closed Excel Workbook

Started by junoon‎, 02-14-2020 04:08 PM

2

770

Last Post By:: Last Post: 02-15-2020 02:04 AM; by junoon

Forum:
Excel Programming / VBA / Macros

Overcoming ADO Recordset 64 Characters limitation for Fields

Started by junoon‎, 02-14-2020 03:41 PM

30

3,306

Last Post By:: Last Post: 02-18-2020 09:57 AM; by Haluk

Forum:
Excel Programming / VBA / Macros

Can I populate a ComboBox from a SQL query?

Started by Izzii0x‎, 12-16-2019 12:44 PM

6

882

Last Post By:: Last Post: 12-20-2019 10:27 AM; by Izzii0x

Forum:
Excel Programming / VBA / Macros

help with ADODB.Connection

Started by Ivancovish‎, 12-06-2019 12:32 AM

5

534

Last Post By:: Last Post: 12-07-2019 12:10 PM; by mjr veverka

Forum:
Excel Programming / VBA / Macros

SSMS SQL Run as a different User from Excel VBA

Started by seaside_escape‎, 11-18-2019 03:37 PM

0

1,007

Last Post By:: Last Post: 11-18-2019 03:37 PM; by seaside_escape

Forum:
Excel Programming / VBA / Macros

[SOLVED] Join 2 csv files from different paths having spaces, using ACE.OLEDB.12 in Excel VBA

Started by junoon‎, 10-05-2019 04:35 AM

11

837

Last Post By:: Last Post: 10-06-2019 08:35 AM; by junoon

Forum:
Excel Programming / VBA / Macros

Hello Hello!

Started by mellownando‎, 10-02-2019 03:17 PM

excel, guitars, music, retail energy, sql

1

378

Last Post By:: Last Post: 10-02-2019 03:19 PM; by arlu1201

Forum:
Hello..Introduce yourself

[SOLVED] Excel and SQL - Update Excel Table

Started by JCabral‎, 09-20-2019 10:31 AM

13

1,053

Last Post By:: Last Post: 09-24-2019 03:47 PM; by CK76

Forum:
Excel Programming / VBA / Macros

[SOLVED] Return headers with results in Recordset

Started by mc84excel‎, 09-19-2019 08:12 PM

5

3,085

Last Post By:: Last Post: 10-30-2019 02:45 AM; by Kyle123

Forum:
Excel Programming / VBA / Macros

Using an IF function from data of an embedded query

Started by rosetc16‎, 08-04-2019 08:04 PM

1

420

Last Post By:: Last Post: 08-04-2019 08:20 PM; by benishiryo

Forum:
Excel Formulas & Functions

Insert an information via odbc SQL and do not wait for return

Started by Alexsandro Dobrzansk‎, 05-17-2019 01:29 PM

0

364

Last Post By:: Last Post: 05-17-2019 01:29 PM; by Alexsandro Dobrzansk

Forum:
Excel Programming / VBA / Macros

Search:

Search: Replies Views Search took 0.00 seconds; generated 3 minute(s) ago.

Excel to SQL [PostgreSQL]

VBA code to delete XLSX database record

ODBC Connection to SQL server

[SOLVED] How to combine large datasets with calculations in Excel

Consolidating several columns of values to 1 - new records NOT SUM

[SOLVED] ADODB.recordset.find gives a compile error expected function or variable

[SOLVED] recordset "WHERE" failing

Summarize data

[SOLVED] Code Improvement - SQL Statement Update SharePoint List

Excel ruins the order of columns when imported if renaming an alias of one of the columns

How to query an open ListObject?

Use dynamic file for SQL query instead of static code

Excel 365 VBA: Filter sql query with form

Getting actual date fields from a SQL refresh

[SOLVED] pivot table - second record - from SQL server

[SOLVED] Excel VBA SQL ADO Recordset Returning Old Cached Results

When is Excel better than SQL?

Unable to find data sources in Excel spreadsheet

Query 4 tables so Slow

Acces Query in Power Query

[SOLVED] SQL join syntax error

WorkbookConnection.Refreshing not triggering in a while sleep(1000) loop

VBA Excel to UPDATE SharePoint Lists and Libraries

Linking Offline Data Adjacent to PivotTable Row Data

Import Images/Pictures/Shapes from a Closed Excel Workbook

Overcoming ADO Recordset 64 Characters limitation for Fields

Can I populate a ComboBox from a SQL query?

help with ADODB.Connection

SSMS SQL Run as a different User from Excel VBA

[SOLVED] Join 2 csv files from different paths having spaces, using ACE.OLEDB.12 in Excel VBA

Hello Hello!

[SOLVED] Excel and SQL - Update Excel Table

[SOLVED] Return headers with results in Recordset

Using an IF function from data of an embedded query

Insert an information via odbc SQL and do not wait for return