Dynamic AI - Microsoft Excel 97-2003

Support documents related to Microsoft SQL Server, Microsoft SQL Server Express, Microsoft Access and Microsoft Excel Databases

Dynamic AI - Microsoft Excel 97-2003

Postby Carsten Sørensen » Sun Jan 18, 2009 12:45 pm

Connecting Dynamic AI to Microsoft Excel 97-2003


In order to connect Dynamic AI to an Excel 97-2003 file, switch to the database tab (at the bottom of the screen) and create a New Database connection. Then select Excel Spreadsheet from the Type list.

Be aware that connecting to Excel Spreadsheets in the format 97-2003 is different than connecting to Excel 2007 (please see separate topic).

Use browse to find and specify the Excel file OR type the full path to the file.

Browse will only be available when you are using Dynamic AI on the same PC as where you have installed Dynamic AI. If you setup connection on a Dynamic AI Server or Enterprise edition - be aware that you should specify the path as seen from the server.

Image

Be aware that Excel is a file-based “database” and that the windows user used by the Dynamic AI installation has sufficient (read/write) access rights to the file.

Also be aware that Dynamic AI will try to open the file exclusively – therefore you will get the following message if the file is already open:

[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

Test the connection by pressing the ‘Test Connection’ button.

Click SAVE to save the connection. Now you should see the new database connection in the database Explore and be able to browse and use defined ranges of data from the file:

Image

Image




ODBC driver

In most cases the necessary driver for connecting to Excel is already present. However if you have problems connecting to an Excel spreadsheet please check the Drivers tab of the ODBC Data Source Administrator found under Administrative Tools in the Control Panel.

Image

If there is no ODBC driver installed you can download the MDAC client from:
http://www.microsoft.com/downloads/deta ... laylang=en

This driver contains core Data Access components such as Microsoft SQL Server, OLE DB provider and ODBC driver.

Sample data

The DEMO optionally installed with Dynamic AI includes a sample Microsoft Excel DEMO file (Sample_95.xls) connected to Dynamic AI and used for reports.




Interested in a free Dynamic AI Personal edition? Download the latest version from: http://www.dynamicai.com/download.htm

Would you like a Dynamic AI Server edition trial version please contact: info@dataaccess.nl

If you have any questions, you are always welcome to contact one of our partners (more information available at: www.dynamicai.eu , www.dynamicai.com) in your country, or e-mail your questions directly to: info@dataaccess.nl




Copyright © 1998-2009 CINTAC A/S and/or its suppliers. All rights reserved. Dynamic AI ™, Dynamic Financials ® and CINTAC Dynamic are registered trademarks or trademarks of CINTAC A/S.
Microsoft, Windows and Excel are registered trademarks of Microsoft Corporation. All other products may be trademarks or registered trademarks of their respective companies.
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Return to Microsoft SQL Server / Express / Access / Excel

cron