Can two tables be MERGED into one? in Access Database design  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Rocio_LB 8/11/2006 9:57 AM PST
  Question
  I am at the stage of designing a database and have created 3 different
tables, each with a logical block of information (fields). However, I am
finding that perhaps the data would be better off in a single table.

At this time, the database does not yet contain any data and I wonder if
there is a way of merging two tables into one saving me the task of having to
add each field and properties all over again.

Your assistance will be greatly appreciated. Thank you!
Rocio Lopez-Bretzlaff
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Duane Hookom 8/11/2006 10:07 AM PST
  Answer
  I believe you can select and copy the fields while in table design and then
paste them into the table design of the target table.

--
Duane Hookom
MS Access MVP

"Rocio_LB" <RocioLB@discussions.microsoft.com> wrote in message
news:07E03A83-271D-43D1-9766-DB56BA1F62FD@microsoft.com...
>I am at the stage of designing a database and have created 3 different
> tables, each with a logical block of information (fields). However, I am
> finding that perhaps the data would be better off in a single table.
>
> At this time, the database does not yet contain any data and I wonder if
> there is a way of merging two tables into one saving me the task of having
> to
> add each field and properties all over again.
>
> Your assistance will be greatly appreciated. Thank you!
> Rocio Lopez-Bretzlaff
>


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Rocio_LB 8/11/2006 10:44 AM PST
   
  Thank you Duane, this actually works!
Rocio Lopez-Bretzlaff

"Duane Hookom" wrote:

> I believe you can select and copy the fields while in table design and then
> paste them into the table design of the target table.
>
> --
> Duane Hookom
> MS Access MVP
>
> "Rocio_LB" <RocioLB@discussions.microsoft.com> wrote in message
> news:07E03A83-271D-43D1-9766-DB56BA1F62FD@microsoft.com...
> >I am at the stage of designing a database and have created 3 different
> > tables, each with a logical block of information (fields). However, I am
> > finding that perhaps the data would be better off in a single table.
> >
> > At this time, the database does not yet contain any data and I wonder if
> > there is a way of merging two tables into one saving me the task of having
> > to
> > add each field and properties all over again.
> >
> > Your assistance will be greatly appreciated. Thank you!
> > Rocio Lopez-Bretzlaff
> >
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Duane Hookom 8/11/2006 11:27 AM PST
   
  Don't act so surprised ;-)

--
Duane Hookom
MS Access MVP

"Rocio_LB" <RocioLB@discussions.microsoft.com> wrote in message
news:977ABAEF-CBE4-4C6F-9DBD-B0B900BAB21E@microsoft.com...
> Thank you Duane, this actually works!
> Rocio Lopez-Bretzlaff
>
> "Duane Hookom" wrote:
>
>> I believe you can select and copy the fields while in table design and
>> then
>> paste them into the table design of the target table.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>> "Rocio_LB" <RocioLB@discussions.microsoft.com> wrote in message
>> news:07E03A83-271D-43D1-9766-DB56BA1F62FD@microsoft.com...
>> >I am at the stage of designing a database and have created 3 different
>> > tables, each with a logical block of information (fields). However, I
>> > am
>> > finding that perhaps the data would be better off in a single table.
>> >
>> > At this time, the database does not yet contain any data and I wonder
>> > if
>> > there is a way of merging two tables into one saving me the task of
>> > having
>> > to
>> > add each field and properties all over again.
>> >
>> > Your assistance will be greatly appreciated. Thank you!
>> > Rocio Lopez-Bretzlaff
>> >
>>
>>
>>


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies