SHAZAM Community
Ask Your Question

Revision history [back]

The easiest way to do this is to open them using the Open button on the File menu.

In this way the file can be opened like any other file. If you then save the Dataset that appears in the Data Editor it will be in SHAZAM format and can be read in either automatically if you add it to your Workspace or using a READ statement.

The driver underpinning the Data Connector is whichever is on your system. Please can you add a comment below this to tell me which version of Windows and which version of Excel is on your computer.

The easiest way to do this is to open them using the Open button on the File menu.

In this way the file can be opened like any other file. If you then save the Dataset that appears in the Data Editor it will be in SHAZAM format and can be read in either automatically if you add it to your Workspace or you can do it manually using a READ statement.statement e.g. if you need to apply formatting to the READ.

The driver underpinning the Data Connector is whichever is on your system. Please can you add a comment below this to tell me which version of Windows and which version of Excel is on your computer.

computer.

In versions 9 and 10, 10.1 and 10.2 if you do not have Excel on the computer you may still open Excel files in SHAZAM if you install Microsoft Data Access Components (MDAC). There is a Component Checker from Microsoft you can use for this purpose (http://support.microsoft.com/kb/301202.

In version 11 or later SHAZAM contains native support for Excel on the Open menu but retains the support for ADO and ODBC as well as native support for Oracle, SQL Server etc on the Data Connector. Note that the Data Connector ships only with the Professional Edition.