NotesTable Wizard for MS Access
INSTANTLY IMPORT LOTUS NOTES DATA INTO MS ACCESS!
The NotesTable Wizard is an Add-In that gives you the power to import your Lotus Notes View data directly into MS 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 MS 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 AN MS ACCESS DATABASE...
The NotesTable Wizard will allow you to import all your Views into MS Access at once, to easily convert an entire Lotus Notes database into an MS Access database.
Then once you have your MS 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.
Easily convert a Lotus Notes database into an MS Access database!
Creates Instantly SQL formatted MS Access tables...
Do more with your Lotus Notes data!
Microsoft Access 97, 2000, 2002 or 2003 installed
Lotus Notes 3.x, 4.x, 5.x or 6.x installed
Price is only $59.95
Buy this software and instantly download to your computer! It's fast, easy and secure.
Copyrightę ACC Technology. All rights reserved. Privacy Statement