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

Easysoft ODBC-ODBC Bridge

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

Article :	00918
Last Reviewed :	28th October 2008
Revision :	2

Operating System: MAC OS X
Application: Microsoft Query X and Microsoft Excel X

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

Easysoft have identified this issue as Microsoft Query X not handling SQL_WVARCHAR column types and the MS SQL Server ODBC driver describes the table name column as SQL_WVARCHAR. 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

*	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)

Easysoft ODBC-ODBC Bridge

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

Applies To

Knowledge Base Feedback