Tools that support Importing directly from Reports

#1

My office often gets accounting data from clients in the form of
reports. These reports can be output into text files but we then need
to parse the report output (not CSV or any other useful import format)
to import it into SQLServer. I have identified a class of tools that
enables a user to open a text file report and mark up the report,
identifying headers, fields, etc so that the report can be parsed and
imported directly into the database. Some of the tools I found are:

- Data Import
- Import Wizard
- TextConverter

I was wondering if anyone has experience using such tools for
importing data? If you do, am I missing any good tools that are "must
have" for this class of problem?

Jerry

#2

"Jerry" <dipalmagerald (AT) gmail (DOT) com> wrote

Quote:

My office often gets accounting data from clients in the form of
reports. These reports can be output into text files but we then need
to parse the report output (not CSV or any other useful import format)
to import it into SQLServer. I have identified a class of tools that
enables a user to open a text file report and mark up the report,
identifying headers, fields, etc so that the report can be parsed and
imported directly into the database. Some of the tools I found are:

- Data Import
- Import Wizard
- TextConverter

I was wondering if anyone has experience using such tools for
importing data? If you do, am I missing any good tools that are "must
have" for this class of problem?

I've never used it, but the tool I've seen discussed for this has been
around for something like 20 years, and appears to still be in active
development:
http://www.datawatch.com/_products/monarch_overview.php

#3

On Mar 7, 9:03*am, "Paul Shapiro" <p... (AT) hideme (DOT) broadwayData.com>
wrote:

Quote:

"Jerry" <dipalmager... (AT) gmail (DOT) com> wrote in message

news:0495bbab-7108-485e-93ed-e0170b833d53 (AT) q23g2000yqd (DOT) googlegroups.com...

My office often gets accounting data from clients in the form of
reports. *These reports can be output into text files but we then need
to parse the report output (not CSV or any other useful import format)
to import it into SQLServer. *I have identified a class of tools that
enables a user to open a text file report and mark up the report,
identifying headers, fields, etc so that the report can be parsed and
imported directly into the database. *Some of the tools I found are:

*- Data Import
*- Import Wizard
*- TextConverter

I was wondering if anyone has experience using such tools for
importing data? *If you do, am I missing any good tools that are "must
have" for this class of problem?

I've never used it, but the tool I've seen discussed for this has been
around for something like 20 years, and appears to still be in active
development:http://www.datawatch.com/_products/monarch_overview.php

Thanks for pointing out the Monarch tool. This tool looks like the
gold standard! Thanks again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Tools that support Importing directly from Reports

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Tools that support Importing directly from Reports - 03-07-2010 , 06:32 AM

Re: Tools that support Importing directly from Reports - 03-07-2010 , 08:03 AM

Re: Tools that support Importing directly from Reports - 03-08-2010 , 08:27 AM