I am new to access. I am doing some data comapre of different files A before
and after situation.

I have 2 files with the same headings. In a perfect world both tables would
be identical. I know how to import the tables and create a query to show
each column side by side. Unfortunately there are 3600 lines of data across
several columns. Too much for a visual comapre. Currently I am copy the
compare query I created into Excel and then creating a new table to only me
show me data that differs.

I would think there is a way to do this all in Access. Any suggestions
would be helpful
--
Thanks
ETC

The query wizard has a Find Differences Query. Give that a try.

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com


"Sweetetc" <(E-Mail Removed)> wrote in message
news:8CDD5B7D-3F05-42E2-A5C8-(E-Mail Removed)...
>I am new to access. I am doing some data comapre of different files A
>before
> and after situation.
>
> I have 2 files with the same headings. In a perfect world both tables
> would
> be identical. I know how to import the tables and create a query to show
> each column side by side. Unfortunately there are 3600 lines of data
> across
> several columns. Too much for a visual comapre. Currently I am copy the
> compare query I created into Excel and then creating a new table to only
> me
> show me data that differs.
>
> I would think there is a way to do this all in Access. Any suggestions
> would be helpful
> --
> Thanks
> ETC

Lynn

Thanks for responding. I have access 2000. I tried the Find Unmatched
query wizard and it did not return any records. (I know I have some
difference). ANy other suggestions
--
Thanks
ETC


"Lynn Trapp" wrote:

> The query wizard has a Find Differences Query. Give that a try.
>
> --
>
> Lynn Trapp
> Microsoft MVP (Access)
> www.ltcomputerdesigns.com
>
>
> "Sweetetc" <(E-Mail Removed)> wrote in message
> news:8CDD5B7D-3F05-42E2-A5C8-(E-Mail Removed)...
> >I am new to access. I am doing some data comapre of different files A
> >before
> > and after situation.
> >
> > I have 2 files with the same headings. In a perfect world both tables
> > would
> > be identical. I know how to import the tables and create a query to show
> > each column side by side. Unfortunately there are 3600 lines of data
> > across
> > several columns. Too much for a visual comapre. Currently I am copy the
> > compare query I created into Excel and then creating a new table to only
> > me
> > show me data that differs.
> >
> > I would think there is a way to do this all in Access. Any suggestions
> > would be helpful
> > --
> > Thanks
> > ETC
>
>
>

It may depend on the fields that you are selecting for the comparison. Try
running the wizard and using only a single field that you know has
differences.

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com


"Sweetetc" <(E-Mail Removed)> wrote in message
news:982773A6-A70A-44E9-B033-(E-Mail Removed)...
> Lynn
>
> Thanks for responding. I have access 2000. I tried the Find Unmatched
> query wizard and it did not return any records. (I know I have some
> difference). ANy other suggestions
> --
> Thanks
> ETC
>
>
> "Lynn Trapp" wrote:
>
>> The query wizard has a Find Differences Query. Give that a try.
>>
>> --
>>
>> Lynn Trapp
>> Microsoft MVP (Access)
>> www.ltcomputerdesigns.com
>>
>>
>> "Sweetetc" <(E-Mail Removed)> wrote in message
>> news:8CDD5B7D-3F05-42E2-A5C8-(E-Mail Removed)...
>> >I am new to access. I am doing some data comapre of different files A
>> >before
>> > and after situation.
>> >
>> > I have 2 files with the same headings. In a perfect world both tables
>> > would
>> > be identical. I know how to import the tables and create a query to
>> > show
>> > each column side by side. Unfortunately there are 3600 lines of data
>> > across
>> > several columns. Too much for a visual comapre. Currently I am copy
>> > the
>> > compare query I created into Excel and then creating a new table to
>> > only
>> > me
>> > show me data that differs.
>> >
>> > I would think there is a way to do this all in Access. Any suggestions
>> > would be helpful
>> > --
>> > Thanks
>> > ETC
>>
>>
>>

Lynn Sorry it still does not seem to work. Is there a way to create it
manually without the Wizard--
Thanks
ETC


"Lynn Trapp" wrote:

> It may depend on the fields that you are selecting for the comparison. Try
> running the wizard and using only a single field that you know has
> differences.
>
> --
>
> Lynn Trapp
> Microsoft MVP (Access)
> www.ltcomputerdesigns.com
>
>
> "Sweetetc" <(E-Mail Removed)> wrote in message
> news:982773A6-A70A-44E9-B033-(E-Mail Removed)...
> > Lynn
> >
> > Thanks for responding. I have access 2000. I tried the Find Unmatched
> > query wizard and it did not return any records. (I know I have some
> > difference). ANy other suggestions
> > --
> > Thanks
> > ETC
> >
> >
> > "Lynn Trapp" wrote:
> >
> >> The query wizard has a Find Differences Query. Give that a try.
> >>
> >> --
> >>
> >> Lynn Trapp
> >> Microsoft MVP (Access)
> >> www.ltcomputerdesigns.com
> >>
> >>
> >> "Sweetetc" <(E-Mail Removed)> wrote in message
> >> news:8CDD5B7D-3F05-42E2-A5C8-(E-Mail Removed)...
> >> >I am new to access. I am doing some data comapre of different files A
> >> >before
> >> > and after situation.
> >> >
> >> > I have 2 files with the same headings. In a perfect world both tables
> >> > would
> >> > be identical. I know how to import the tables and create a query to
> >> > show
> >> > each column side by side. Unfortunately there are 3600 lines of data
> >> > across
> >> > several columns. Too much for a visual comapre. Currently I am copy
> >> > the
> >> > compare query I created into Excel and then creating a new table to
> >> > only
> >> > me
> >> > show me data that differs.
> >> >
> >> > I would think there is a way to do this all in Access. Any suggestions
> >> > would be helpful
> >> > --
> >> > Thanks
> >> > ETC
> >>
> >>
> >>
>
>
>