DataImport lets you import any report or text file

DataImport

DataImport Overview

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 report. A wealth of features are provided to give you complete control of the import process.

For example, you can tell DataImport to extract only rows that contain the word "Chicago" or only rows where the amount is over $10,000. It can even pull data up from a footer, such as a total line, and put it on the lines above it. Or, take data from a section heading and put it on the lines below it. DataImport neatly extracts all of the data, rearranges it and places it into the spreadsheet columns or database fields that you specify.

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.