![]() Database: The name of the SQL Server database.Ĭonnecting to Azure SQL Server and Azure Data Warehouse.Password: The password associated with the authenticating user.User: The username provided for authentication with SQL Server.Server: The name of the server running SQL Server.You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.Ĭonnect to Microsoft SQL Server using the following properties: This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name). Follow the steps below to use Microsoft Query to import SQL Server data into a spreadsheet and provide values to a parameterized query from cells in a spreadsheet. The CData ODBC driver for SQL Server uses the standard ODBC interface to link SQL Server data with applications like Microsoft Access and Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |