Microsoft KB Archive/238283

= MacXL: "Data Truncated" Error Message Connecting to SQL Server 7.0 Database =

Article ID: 238283

Article Last Modified on 6/12/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q238283



SYMPTOMS
When you click OK in the VSI MS SQL Server dialog box, you receive one or both of the following error messages:

Data truncated

-or-

Couldn't read this file.



CAUSE
This problem occurs when you attempt to connect to a Microsoft SQL Server 7.0 database. The SQL Server ODBC driver that is included with Microsoft Excel 98 Macintosh Edition does not support connecting to a SQL Server 7.0 database. Microsoft Excel 2001 for Mac does install any ODBC drivers.



WORKAROUND
To connect to a SQL 7.0 driver, you can purchase a driver from a third-party company. The following companies are a few that may have this driver:

Attunity

Phone: (781) 221-1450

Fax: (617) 272-2531

http://www.attunity.com

Centura Software Corp.

Phone: (415) 321-9500

Fax: (415) 321-5471

http://www.centurasoft.com

MERANT plc

Phone: (800) 876-3101, (919) 461-4200

Fax: (919) 461-4526



MORE INFORMATION
Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

For information about how to contact third-party companies, click the appropriate article number in the following list to view the article in the Microsoft Knowledge Base:

65416 Hardware and Software Third-Party Vendor Contact List, A-K

60781 Hardware and Software Third-Party Vendor Contact List, L-P

60782 Hardware and Software Third-Party Vendor Contact List, Q-Z

Additional query words: XL98 visigenic Excel XL2001 XL SQL query ODBC driver

Keywords: kbprb KB238283

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.