Import Wizard 8.2.0f

Import Wizard will help you to easily import text based report files into MS-Access, MS-Excel, MySQL, SQL-Server, MSDE, Oracle, etc.
The software goes beyond the standard text import functionality by allowing imports with multiple lines per record and importing headers. The software will prove to be very useful to import information from 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 computer systems have a provision to print reports to a printer spool file instead of printing directly to a printer. Import Wizard uses these printer spool files to create tables. It accomplishes this by using an import model. With the included wizard it is possible to define these models within minutes.
This software will save you a lot of time and headaches trying to figure out a way to transfer data between systems. Import Wizard is available as an add-in for Access and Excel, and as a standalone application running under Windows 95/98/ME/NT4/2000/XP operating systems.
Main features:
- Included MS Office Add-Ins provide seamless integration with Microsoft Access and MS Excel 97, 2000, XP (2002), and 2003.
- Included standalone executable can manipulate data regardless of whether Access and Excel are installed on the PC.
- Import standard and non-standard text files, delimited and fixed width files, as well as HTML tables from web pages.
- Import text files created by any applications reporting functionality.
- Import files from Windows, legacy DOS, or mainframe systems.
- Output imported data into Access, Excel, SQL-Server, Oracle, ODBC databases, dBase, XML, HTML, or delimited text.
- Save import definitions for repeated use.
- Use wildcard characters to import multiple files or whole directories in a single go.
- Apply filters to restrict what is imported.
- Data type conversion for non-standard date and numeric formats.
- Import multi-line data, such as a multiple-row street addres, into a single field.
- Split fields into subfields, such as zipcode and city.
- Create fields that store formula results based on source data.
- Access and Excel add-ins provide VBA functions that let you automate the import process, the standalone version can be automated using commandline options.
- Runs on Windows 95/98/ME/NT4/2000/XP (Access 97/2000/XP/2003 or Excel 97/2000/XP/2003 are optional).