Re: Compare two flat files

[Sam Spritzer <teknogeek9@YAHOO.COM>]

Maria,
Since you already have an unmatched query that works for you in Access,
transfer that SQL statement over to SQR and make whatever changes you need.
Obviously, in Access, you are doing an OUTER join as I had suggested earlier.
Sam


--- "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


=====
************************************************************
"In the beginning, there was something...which exploded yet, they find nothing."

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