Import Wizard enables you to easily import text based report files into MS-Access, Excel, MS-SQL Server, MSDE, MySQL, or other databases. The software goes beyond the standard text import functionality by allowing imports with multiple lines per record and importing headers and footers. The software will prove to be very useful to import information from web transactions, mainframe, non-windows based, or secured systems. The imported information can be manipulated as a table in the database into which it was imported. How does it work? Ninety-nine percent of software systems have a provision to print reports to a printer spool file instead of printing directly to a printer. This software uses these printer spool files to create tables. It accomplishes this by using an import model. The software includes a wizard to define these models within minutes. This software will save you a lot of headaches trying to figure out a way to transfer data between systems. Import Wizard includes a standalone executable and add-ins for MS-Access and MS-Excel.
Save MS Access tables to text or CSV files.
Load text files (or csv files) to MS Access.
Use Excel to import, export Access tables.
Send MS Access tables to Excel worksheets.
Transfer tables to and from Access and MySQL.