 |
Import Wizard 9.2.1 |
 |
Import Wizard 9.2.1
Publisher's Description:
Import Wizard - 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 Access and Excel 97 or later.
Social bookmarks:           RSS:      
Latest User Reviews:
Version: 9.2.1
 Almost!
I've loved the import wizard, and have a particularly tough nut to crack, which the IW ALMOST solved for me.
I need to translate structured text files from a groupware session software into a database for reporting purposes. There are different record types in the file, and thus I need to output to different tables, from the same text file. I would love to see this feature.
In addition, while ther is a ";" delimiter in the file, the delimited fields contain both the field name as well as the data, for example ;fieldname1=This is the fields content;fieldname2=22;fieldname3=another string; etc. etc.
not sure I can solve translating fields with both delimiters and field names (I've been able to use mid$ like functions, but these fields also can occur in different columns)
Anyway, it's good software, is about the closest I've come to solving my problem, but doesn't quite solve it for me...
Social bookmarks: RSS:
|
Audio & Multimedia
Business
Accounting & Finance
JB
2006-11-11 01:31:12
