The query tool used by SQL Server Compact is dependent on the Visual Studio version: Use Transact-SQL Editor in Visual Studio 2010. Use Server Explorer or Query Designer in Visual Studio 2005 and later. HeidiSQL is a database query tool that supports MySQL, Microsoft SQL Server and PostreSQL databases. It allows you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events.
Tool Description Runs on; Azure Data Studio: Azure Data Studio is a free, light-weight tool, for managing databases wherever they're running. This preview release provides database management features, including an extended Transact-SQL editor and customizable insights into the operational state of your databases.
This question already has an answer here:
Is there a way to get ADODB to work with Excel for Mac 2011? 3 answers
Mysql Query Tool
I have write a macro in Excel 2016 on a windows pc via oledb connection. But it doesn't work in my Mac. How can I run this? Normally, in windows, you choose tools > references and check oledb connection but there isn't a tools option in Excel Mac. I don't know code is important here but I'll share it anyway.
Community♦
ali srnali srn
marked as duplicate by David Zemens excel-vbaNov 2 '16 at 20:09
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
1 Answer
Your code uses late-binding and doesn't require a 'Reference' so long as the library is available on the machine. In your case on Mac OS, the library doesn't exist and is, as far as I know, explicitly not allowed.
From Microsoft (emphasis added):
To import data from a database, such as Microsoft SQL Server, you must have an ODBC driver that is compatible with Microsoft Query installed on your computer. Compatible ODBC drivers are available from third-party vendors. For more information, see ODBC drivers that are compatible with Excel for Mac. For more information about installing ODBC drivers, see Microsoft Query Help.
Importantly, for your question, OLE DB is explicitly not supported on Mac OS if using Excel 2011 for Mac.
Excel 2011 for Mac cannot import data from OLE DB or OLAP data sources.
So, to answer your question there is no way to get your SQL query to work on Mac, you need to use something else entirely.
HOWEVER, as noted, if you're using Excel 2016 for Mac, you can do it:
This version of Excel does provide an ODBC driver for connecting to SQL Server Databases. On the Data tab, click New Database Query > SQL Server ODBC. Then use the dialog boxes to import the data.
If you are connecting to other ODBC data sources (for example, FileMaker Pro), then you'll need to install the ODBC driver for the data source on your Mac. Windows mysql gui client. Drivers that are compatible with Excel for Mac are available from these companies:
Alternatively, this answer to a similar question looks promising:
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Not the answer you're looking for? Browse other questions tagged vbaexcel-vbaoledbexcel-vba-macexcel or ask your own question.
The MS SQL Server database query tool features provided by RazorSQL include a custom MS SQL Server database browser tailored to SQL Server, a Transact-SQL SQL editor with Transact SQL and SQL Server specific features and syntax highlighting, custom SQL Server visual tools, and SQL Server specific database administration tools. Listed below are more details on these features.
A SQL Server create table tool that generates SQL Server specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, nullability, unique constraints, default values, identity, identity start and end, and the ability to add check constraints.
MS SQL Server Database Backup Tools for backing up MS SQL Server databases or single MS SQL Server tables.
A SQL Server create view tool that generates the SQL for creating SQL Server views
A SQL Server create index tool that generates the SQL for creating SQL Server indexes and includes elements such as index name, uniqueness, and columns
A SQL Server create procedure tool for generating the TSQL to create SQL Server procedures
A SQL Server create function tool for generating the TSQL to create SQL Server functions
A SQL Server create trigger tool for generating the TSQL to create SQL Server triggers
A SQL Server create database tool that generates the SQL Server create database SQL with elements such as database name, logical file name, file name, size, max size, file growth, collation, etc.
A SQL Server alter table tool for generating the SQL to alter SQL Server tables with such options as add column, add primary key, add foreign key, add constraint, rename table, rename column, drop column, drop primary key, drop foreign key, and drop constraint
A SQL Server alter view tool for generating the SQL to alter SQL Server views
SQL Server Drop Tools for dropping tables, views, indexes, procedures, functions, and triggers for SQL Server
A visual edit table tool for visually editing SQL Server tables in a spreadsheet format
Tools for editing procedures, functions, and triggers for SQL Server.
SQL Server Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database
A Generate DDL Tool for SQL Server for generating MS SQL Server table, view, and index DDL.
See the SQL Server Database Management Tool page for more information on management features
Displays information in a tree format for databases, tables, views, procedures, functions, triggers, indexes, constraints, users, and roles
Displays SQL Server table information such as column name, column type, column length, column nullability, and primary and foreign key information
Easily view table contents or database object information via the View Contents and Show Info context menu options
Edit SQL scripts. Run SQL queries. Auto column and auto table lookup. Supports over 20 programming languages including SQL, Transact-SQL, PHP, HTML, XML, Java, and more.
Import data from various formats such as delimited files, Excel spreadsheets, and fixed width files.
Export data in various formats such as delimited files, Excel spreadsheets, text, HTML, XML, and SQL insert statements.
Edit tables in a spreadsheet format with support for finding and replacing data, automatic generation of SQL, and support for editing multi-line data.