Yahoo Poland Wyszukiwanie w Internecie

Search results

1. stackoverflow.com › questions › 27385245sql server - Using Excel VBA to run SQL query - Stack Overflow

   stackoverflow.com › questions › 27385245

   You need to make sure you have the proper ADODB reference [VBA Editor->Tools->References] and make sure you have Microsoft ActiveX Data Objects 2.8 Library checked, which is the second from the bottom row that is checked (I'm using Excel 2010 on Windows 7; you might have a slightly different ActiveX version, but it will still begin with ...

2. learn.microsoft.com › en-us › sqlDownload Microsoft OLE DB Driver for SQL Server

   learn.microsoft.com › en-us › sql

   • Zapisane w pamięci cache

   9 lip 2024 · Download the Microsoft OLE DB Driver for SQL Server to develop native Windows applications that connect to SQL Server and Azure SQL Database.

3. stackoverflow.com › questions › 76072752How to connect to an SQL Server from VBA in Excel?

   stackoverflow.com › questions › 76072752

   21 kwi 2023 · I need to download some data from a database (Microsoft Windows Server 2012, SQL Server 2012) into Excel (Windows 11, Office 2016). If it was a one-time data dump I'd just use Data -> Get Data -> From Database and use the resulting sheet.

4. codingsight.com › 32-bit-excel-and-64-bit-sql-server32-bit Excel and 64-bit SQL Server - {coding}Sight

   codingsight.com › 32-bit-excel-and-64-bit-sql-server

   • Zapisane w pamięci cache

   30 paź 2017 · The article describes the way of retrieving the data from a 32-bit Excel table in 64-bit SQL Server using the linked servers.

5. stackoverflow.com › questions › 1954128How do I connect to my 64-bit SQL Server with ODBC?

   stackoverflow.com › questions › 1954128

   To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe. If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver you will receive this message. edited Jul 24, 2012 at 3:14. Anthony.

6. www.ptr.co.uk › blog › using-excel-vba-query-sql-server-databaseUsing Excel VBA to Query a SQL Server Database - PTR

   www.ptr.co.uk › blog › using-excel-vba-query-sql-server-database

   • Zapisane w pamięci cache

   The VBA To Query a SQL Server Database. The following VBA Function can be used from within an Excel VBA Project. You will, however need to add the ADODB library to the project first.

7. simpleexcelvba.com › how-to-connect-to-microsoft-sql-server-using-vbaHow to connect to Microsoft SQL Server using VBA?

   simpleexcelvba.com › how-to-connect-to-microsoft-sql-server-using-vba

   • Zapisane w pamięci cache

   19 sie 2021 · In this article I’m going to show You how to connect to Microsoft SQL Server using VBA. Database & server In my case I got AdventureWorks2016 database installed on my PC.