Easysoft ODBC-ODBC Bridge

Why cannot I see my tables in Excel/Query for MAC OS X?

When you start a new worksheet and use Data > Get External Data > New Database Query, select a data source and click on Show Tables, Microsoft Query X displays the tables dialog, but no tables are shown. You can click on lines in the tables dialog and scroll up and down, but all the table names are blank.

The reason for this is that the Microsoft SQL Server ODBC driver describes the table name column as SQL_WVARCHAR, but Microsoft Query X does not handle SQL_WVARCHAR column types. To work around this, you need to add:

DisguiseWide=1

to the data source you are using.

Applies To

• Products
  • Easysoft ODBC-ODBC Bridge
• Databases
  • Microsoft SQL Server
• Applications
  • Microsoft Excel
  • Microsoft Office

Knowledge Base Feedback

* Did this content help you?

Yes No Maybe

* Please select one option based on your first choice:

I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

Suggest new content or let us know how we can improve this content:

(* Required Fields)

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• Blog
• Careers

• Products

• ODBC Drivers
• JDBC Drivers
• Bridges and Gateways
• In Development

• Services

• Consultancy
• Training
• Custom Development

• Licensing

• Product Licenses
• Prices

• Support

• Support Home
• Solution Wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer Area
• Client Applications

• Legal

• Privacy Statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
• 
•