Posted by Ed Murphy on 05/03/07 04:38

Mark S wrote:

> Not to belabor the point (versus to more fully explain), but say I have two
> data sets
>
> [ Company Name | Address ]
>
> and
>
> [ Company Name | Phone ]
>
> and I want to import them both into a database with separate three tables:
>
> 1. Company Name
> 2. Address
> 3. Phone
>
> What is the least labour intensive way to effect this??

I would create a table with columns (name, address, phone), import
into it, then use queries to copy its data to the other tables.

[Back to original message]