NotesTable Wizard for Microsoft Access

INSTANTLY IMPORT LOTUS NOTES DATA INTO MICROSOFT ACCESS!

The NotesTable Wizard is an Add-In that gives you the power to import your Lotus Notes View data directly into Microsoft Access and create proper SQL formatted tables. With the NotesTable Wizard you can import the data off a Notes Server or from a local NSF file. You can choose to create a new table or append an existing table. Best of all, there are no complicated ODBC drivers or any other installation process required. The NotesTable Wizard imports the data using advanced OLE Automation.

The NotesTable Wizard cleans your field names by removing spaces and converting non SQL passable characters into an underscore. And View columns that have no name are given a field name as a column number. Plus, you can save the specifications of an import to easily rerun the import again and to keep track of your imports, a log is kept of when each import was last run.

USE IT TO AUTOMATE ROUTINE PROCESSES...

You can use the NotesTable Wizard as part of a process to automate routine reporting, data updating or archiving. Once you have your data imported into Microsoft Access, you can do more with your data and go beyond what Lotus Notes can do alone... You can join data, create Relationships, write Queries and work with Recordsets.

OR, CONVERT A LOTUS NOTES DATABASE INTO A MICROSOFT ACCESS DATABASE...

The NotesTable Wizard will allow you to import all your Views into Microsoft Access at once, to easily convert an entire Lotus Notes database into an Microsoft Access database.

Then once you have your Microsoft Access tables created, you can set-up data types, model data relationships, create indexes and eliminate redundant data. Plus, once you have developed a workable database model, it becomes easy to migrate your data to any other popular relational database system, such as Oracle or Microsoft SQL Server.

Screenshot

Easily convert a Lotus Notes database into an Microsoft Access database!

Creates Instantly SQL formatted Microsoft Access tables...

Do more with your Lotus Notes data!

System Requirements:
Microsoft Access 97, 2000, 2003 or 2007 installed
Lotus Notes 3.x, 4.x, 5.x, 6.x, 7.x or 8.x installed

Price is only $59.95

Buy this software and instantly download to your computer! It's fast, easy and secure.

Or, if your a VBA programmer and want to develop customized automation solution for importing Lotus Notes data into Microsoft Access then have a look at the NotesTable Reference Library