Developers number one Connection Strings reference Knowledge Base Q & A forums

About Contribute log in

vba code to extract data from sql

I'm trying to export the data from multiple database from a single server into one excel using VBA code. Please can anyone help.

0

share edit delete

are you sure?

asked Dec 08, 2016 Sheik Sulthan

1 answer

Pandora One Apk

0

share edit delete

are you sure?

answered Nov 11, 2017 wwede wdwd

Post an answer but please log in first

Post Answer

Please log in to post answer

Similar Questions

Excel VBA and sqlite : personnal dlls path

Hello, i'm working on a portable app with Excel VBA and sqlite, i would like to specify a personal path for dlls in the connection String. can you help me with that ' Chemins personnalisés vers les DLLs et Base de données

0 votes

0 answers

Anonymous user • 3 weeks ago

Conectar a dos listas de sharepoint on line para consulta SQL con JOIN

Buenas tardes Desde EXCEL VBA Necesito conectarme a dos listas de sharepoint on line para realizar una consulta SQL a las dos listas utilizando JOIN, pero me da error porque no reconoce los nombres dos listas.

Excel 2013 SharePoint Excel

0 votes

0 answers

ALEJANDRO M • 3 months ago

Multiple SQL database Connection

How to connect multiple database using sql server

SQL Server 2019 SQL Server

0 votes

0 answers

Anonymous user • 4 months ago

Connecting to Excel DataTables

Hi am currently wrtting a vba subroutine that i want to use in order to query a datatable in a worksheet, and then load the recordset into a different datatable in my current worksheet.

0 votes

0 answers

Jakob Espinoza • 6 months ago

connect exe to ssms pinn database while install in other pc

exe.config, exe,database available after instal ssms in other pc unable to connect to database from exe to database, exe opening, database opening in sql server, but in exe login form user not showing , means data not showing, kindly help to connect it

SQL Server 2008 Integration Services SQL Server

0 votes

0 answers

ari creationz • 6 months ago

How to enable Column always encrypted to SQL server via OLEDB provider

How to enable Column always encrypted to SQL server via OLEDB provider

0 votes

0 answers

Mahmoud Hassan Abouleila • 10 months ago

Do you have an Page for Azure SQL Server Managed Instance?

Do you have an entry for Azure SQL Server Managed Instance? I see for Azure SQL. but Azure SQL Managed instance can hold multiple databases

0 votes

0 answers

Luis LL • 11 months ago

ADOODB Connection error Excel 16 32, bit OLE DB providers

Connection String for Excel 2016 32 bit. The script work without a problem on Office365 Excel version, When the same file is sent to a different user with excel 2016. It get Connection initiation error. "An Error occurred after the connection was established" .

0 votes

0 answers

Abin Alex • Dec 13, 2023

connetion between the win app and web app

Hello everyone; I need you kind help to solve the following connectionString Data Source=11.111.111.11,1433;(localdb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\mydbase.mdf;Initial Catalog=mydbase;User Id=Ibrahim;Password=?????????

0 votes

0 answers

Ibrahim Khalifi • Oct 14, 2023

SQL Server authenticated on localhost but not when using IP address

Hello, I wonder if you can give me some direction. I have a SQL site developed for data forms inputs by my brother-in-law, a password was given to me to do misc. admin stuff like adding users and data inputs.

SQL Server SQL Server 2019

0 votes

0 answers

Hiep Tang • Jun 16, 2023

Load more posts

Tagsfor this question

Excel 2013×30 SQL Server 2008×52 Excel×130 SQL Server×214

Forum

Access×161 Access 2000×8 Access 2002×4 Access 2003×15 Access 2007×29 Access 2010×29 Access 2013×45 Access 97×6 Active Directory×9 AS/400×13 Azure SQL Database×22 Caché×1 Composite Information Server×2 ComputerEase×2 DBF / FoxPro×20 DBMaker×1 DSN×21 Excel×130 Excel 2000×2 Excel 2002×2 Excel 2003×10 Excel 2007×16 Excel 2010×22 Excel 2013×30 Excel 97×4 Exchange×1 Filemaker×1 Firebird×9 HTML Table×3 IBM DB2×17 Informix×8 Integration Services×6 Interbase×2 Intuit QuickBase×1 Lotus Notes×3 Mimer SQL×1 MS Project×2 MySQL×63 Netezza DBMS×4 OData×3 OLAP, Analysis Services×3 OpenOffice SpreadSheet×2 Oracle×63 Paradox×3 Pervasive×6 PostgreSQL×20 Progress×4 SAS×5 SAS IOM×1 SAS OLAP×2 SAS Workspace×2 SAS/SHARE×2 SharePoint×20 SQL Server×214 SQL Server 2000×8 SQL Server 2005×13 SQL Server 2008×52 SQL Server 2012×35 SQL Server 2014×9 SQL Server 2016×12 SQL Server 2017×2 SQL Server 2019×4 SQL Server 7.0×3 SQL Server Compact×11 SQLBase×7 SQLite×17 Sybase Adaptive×13 Sybase Advantage×6 Teradata×4 Textfile×8 UDL×3 UniData×1 UniVerse×1 Visual FoxPro×10 Windows Azure Storage×4

connectionstrings articles search Q & A ask question contribute retro about contact log in join

Copyright 2024, © ConnectionStrings.com - All Rights Reserved

Powered by CSAS on .NET 8.0.7

Made possible by Contributing Developers