DataImport 6 extracts data from reports of nearly any complexity and outputs it into spreadsheet, database and other useful file formats. This includes Microsoft Access, Excel, HTML tables, XML tables, delimited, dBase and nearly 40 other file types. With DataImport, you can quickly and easily mine data from files such as mainframe reports, data dumps, print-to-disk files, downloaded information, or most any other type of text file.
If you have become frustrated with the meager import features found in Excel, Access and other applications, you need DataImport. It specializes in giving you the tools needed to pull data from complex multilevel reports and forms. DataImport unlocks the data trapped in page headings, section headings, multiple detail lines, total lines, footers, and summaries.
With DataImport’s easy, intuitive, point-and-click interface, you select just the data you want. Whether it is specific columns of data, rows, or sections of a report. A wealth of features are provided to give you complete control of the import process.
DataImport recognizes and properly formats numbers, decimals, percents, dates, times, and the currency of any country. It parses names like “Dr. John A. Smith, Jr.” and places the parts into five separate fields or columns. It will even append to an existing database and output to a specific sheet in an Excel workbook.
All of the selections that you make are saved for repeated use with future versions of the same report. Multiple or repetitive translation jobs are easily automated. DataImport has 15 years of experience solving tough report file translation jobs for thousands of users around the world.
Supported File Types
Microsoft Excel 2.1, 3.0, 4.0, 5.0, 7.0, 97, 2000, XP, 2007 (.xlsx)
- Microsoft Access 1.1, 2.0, 3.0, 97, 4.0, 2000, XP
- XML Table
- HTML Table
- dBase II, III, IV
- Lotus 1-2-3 1A, 2.0, 3.0, 4.0, 5.0
- ASCII
- Comma Separated Value
- Delimited Text
- User-Defined Delimited
- Tab Separated Variable
- Fixed Field Text
- Mailing Label
- Clarion
- Microsoft Word Merge
- Quattro Pro 5.0
- Sylk
- Symphony 1.0, 1.1
- WordPerfect Merge 5.0, 5.1
- Columnwise DIF
- Named Value