|
|
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.
Navigation:
[Reply to this message]
|