Re: Compare two flat files

[Arun Kumar <arunkumar13@YAHOO.COM>]

Maria,
If you are running Oracle, You can ask your DBA to
create dblink then you write sql to get just the
unmatched records.

Even other database might have something similar to
dblink.

HTH
Arun
--- "Brickl, Maria" <mbrickl@UWC.EDU> wrote:
> They are formatted .csv. I want as much automation
> as possible. I could
> easily do this in MS Access by bringing the files in
> there and doing a
> unmatched query but the steps I must take before
> that are too cumbersome.
> Currently to compare a file:
>
> 1.      Run PS Queries to get the different queries
> to excel - one out of
> our SFS system and one from our SA system.
> 2.      Open database in Access and bring in both of
> these excel files using
> Import.
> 3.      Run a unmatched query in access.
> 4.      Save file to csv to be able to load into SA
> the data not in there
> already.
>
> I'm going to have to do this for at least 8
> different other tables and I
> want to make it as much automated as possible.
>
> -----Original Message-----
> From: the dragon [mailto:ceprn@HOTMAIL.COM]
> Sent: Tuesday, April 23, 2002 11:17 AM
> To: SQR-USERS@list.iex.net
> Subject: Re: Compare two flat files
>
>
> I have some information to share, but first, what is
> it you are trying to
> compare - obviously lat files, but are they
> formatted (delimitted flat file)
> or free form (sqr program).  Also, in what
> environment/OS?  How much
> automation do you want, or user intervention?
>
> clark 'the dragon' willis
> dragon enterprises, consulting services
>
>
> PSA: Salary <> Slavery.  If you earn a salary, your
> employer is renting your
> services for 40 hours a week, not purchasing your
> soul.  Your time is the
> only real finite asset that you have, and once used
> it can never be
> recovered, so don't waste it by giving it away.
>
> "Time is the coin of your life. It is the only coin
> you
> have, and only you can determine how it will be
> spent.
> Be careful lest you let other people spend it for
> you."
>
> Carl Sandburg
> (1878 - 1967)
>
>
>
> Does anyone know if it is possible to compare two
> flat files to create a new
> flat file of rows that are in one of the flat files
> but not in the other?
>
>
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
> Maria K Brickl
> Information Systems Programmer/Analyst
> University of Wisconsin Colleges
> 780 Regent St, PO Box 8680, Madison, WI  53708-8680
> Phone: 608.265.2677 / Fax: 608.265.5770
>
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
>
>
>
>
>
>
_________________________________________________________________
> Join the world's largest e-mail service with MSN
> Hotmail.
> http://www.hotmail.com


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/