I used
Table Tools --> Database Tools --> Analyze Table
to eliminate redundant data. This split my main table into two tables. But
the savings are not great and now I want to bring the data back into the
same table.

Can I do this in Access, or do I need to use VB?

"Jeff Boyce" <(E-Mail Removed)-DISCARD_HYPHEN_TO_END> wrote in message
news:(E-Mail Removed)...
> "savings" of what? Splitting is not necessarily smaller or faster or ...,
> but using a well-normalized relational database design will help ensure
> the
> integrity of your data. What's more important, accurate or fast?
>
> --
> Regards
>
> Jeff Boyce
> www.InformationFutures.net
>
> Microsoft Office/Access MVP
> http://mvp.support.microsoft.com/
>
> Microsoft IT Academy Program Mentor
> http://microsoftitacademy.com/
>
> "mttmwsn" <mttmwsn.@gmail.com> wrote in message
> news74Vi.34941$(E-Mail Removed)...
>> I used
>> Table Tools --> Database Tools --> Analyze Table
>> to eliminate redundant data. This split my main table into two tables.
> But
>> the savings are not great and now I want to bring the data back into the
>> same table.
>>
>> Can I do this in Access, or do I need to use VB?
>>
>>
>

I split my customer database into two databases, Customers and
CustomerAddresses. Since two customers may share the same address I had a
very small amount of duplication. Later I realized that spliting them is
not good design because the co-habiting customers might split, each to a new
address and now I want to go back to the origional plan.

"savings" of what? Splitting is not necessarily smaller or faster or ...,
but using a well-normalized relational database design will help ensure the
integrity of your data. What's more important, accurate or fast?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"mttmwsn" <mttmwsn.@gmail.com> wrote in message
news74Vi.34941$(E-Mail Removed)...
> I used
> Table Tools --> Database Tools --> Analyze Table
> to eliminate redundant data. This split my main table into two tables.
But
> the savings are not great and now I want to bring the data back into the
> same table.
>
> Can I do this in Access, or do I need to use VB?
>
>

"mttmwsn" <mttmwsn.@gmail.com> wrote in message
news74Vi.34941$(E-Mail Removed)...
>I used

> Table Tools --> Database Tools --> Analyze Table
> to eliminate redundant data. This split my main table into two tables.
> But the savings are not great and now I want to bring the data back into
> the same table.
>
> Can I do this in Access, or do I need to use VB?

Just build a query that joins the tables back together. When you open that
query, the data will appear as if the data was one table like before you
split.

You can even edit, or export that table.......

In fact, if memory serves me correct, the analyzer usually makes a query for
you that looks exactly like the data before you split it...so, just use that
query.

You don't need code or anything else...just that query.....

The concept of "joining" the data using a query is the VERY essence of a
relational database...

That resulting query will look like ONE TABLE that can be edited, or
exported. It will *look* like one table, but in fact be two talbes joined.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)

Can you simply replace what you have now with a backup copy of what you had
before?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"mttmwsn" <mttmwsn.@gmail.com> wrote in message
news:9C5Vi.23592$(E-Mail Removed)...
>
> "Jeff Boyce" <(E-Mail Removed)-DISCARD_HYPHEN_TO_END> wrote in message
> news:(E-Mail Removed)...
> > "savings" of what? Splitting is not necessarily smaller or faster or
....,
> > but using a well-normalized relational database design will help ensure
> > the
> > integrity of your data. What's more important, accurate or fast?
> >
> > --
> > Regards
> >
> > Jeff Boyce
> > www.InformationFutures.net
> >
> > Microsoft Office/Access MVP
> > http://mvp.support.microsoft.com/
> >
> > Microsoft IT Academy Program Mentor
> > http://microsoftitacademy.com/
> >
> > "mttmwsn" <mttmwsn.@gmail.com> wrote in message
> > news74Vi.34941$(E-Mail Removed)...
> >> I used
> >> Table Tools --> Database Tools --> Analyze Table
> >> to eliminate redundant data. This split my main table into two tables.
> > But
> >> the savings are not great and now I want to bring the data back into
the
> >> same table.
> >>
> >> Can I do this in Access, or do I need to use VB?
> >>
> >>
> >
>
> I split my customer database into two databases, Customers and
> CustomerAddresses. Since two customers may share the same address I had a
> very small amount of duplication. Later I realized that spliting them is
> not good design because the co-habiting customers might split, each to a
new
> address and now I want to go back to the origional plan.
>
>

Yes, but I will loose data if I go to the backup copy.
"Jeff Boyce" <(E-Mail Removed)-DISCARD_HYPHEN_TO_END> wrote in message
news:(E-Mail Removed)...
> Can you simply replace what you have now with a backup copy of what you
> had
> before?
>
> --
> Regards
>
> Jeff Boyce
> www.InformationFutures.net
>
> Microsoft Office/Access MVP
> http://mvp.support.microsoft.com/
>
> Microsoft IT Academy Program Mentor
> http://microsoftitacademy.com/
>
> "mttmwsn" <mttmwsn.@gmail.com> wrote in message
> news:9C5Vi.23592$(E-Mail Removed)...
>>
>> "Jeff Boyce" <(E-Mail Removed)-DISCARD_HYPHEN_TO_END> wrote in
>> message
>> news:(E-Mail Removed)...
>> > "savings" of what? Splitting is not necessarily smaller or faster or
> ...,
>> > but using a well-normalized relational database design will help ensure
>> > the
>> > integrity of your data. What's more important, accurate or fast?
>> >
>> > --
>> > Regards
>> >
>> > Jeff Boyce
>> > www.InformationFutures.net
>> >
>> > Microsoft Office/Access MVP
>> > http://mvp.support.microsoft.com/
>> >
>> > Microsoft IT Academy Program Mentor
>> > http://microsoftitacademy.com/
>> >
>> > "mttmwsn" <mttmwsn.@gmail.com> wrote in message
>> > news74Vi.34941$(E-Mail Removed)...
>> >> I used
>> >> Table Tools --> Database Tools --> Analyze Table
>> >> to eliminate redundant data. This split my main table into two
>> >> tables.
>> > But
>> >> the savings are not great and now I want to bring the data back into
> the
>> >> same table.
>> >>
>> >> Can I do this in Access, or do I need to use VB?
>> >>
>> >>
>> >
>>
>> I split my customer database into two databases, Customers and
>> CustomerAddresses. Since two customers may share the same address I had
>> a
>> very small amount of duplication. Later I realized that spliting them is
>> not good design because the co-habiting customers might split, each to a
> new
>> address and now I want to go back to the origional plan.
>>
>>
>