Friday, January 16, 2009

Feature Update: Extract from Excel and Access 2007

JangoMail now has tools to help you use Extract from Local Database to connect to Excel 2007 and Access 2007 files. Now users of the most recent versions of these programs can make direct connection without exporting/importing.

To get started, go to the Extract from My Database page and click to Connect to Local Database. On that screen, you'll choose to Create Profile (experts only).

Then, you'll be able to create a name to save the profile and use the Connection String links to build the proper syntax for linking to your file. In the example below, we are connecting to an Excel 2007 file.

This prepopulates the Connection String box with general information and the name of a "placeholder" file for the "Data Source=" section. In the example, the file is at: c:\myFolder\myExcel2007file.xlsx.

You will replace the placeholder file path and file name with the true path and name of your existing file and modify the SQL Query as appropriate to generate the list desired.