Posted by Mark S on 05/03/07 03:59

Also, (though it is the same issue essentially) what if the first
dataset is Company Name, Address, City where each different city is
listed from 1 to ? number of times -- is there a way the dbase can
know that say New York only needs to be added once to a City table and
then the other tables just have a reference to that ID in the city
table?

"Mark S" <bob@bob.com> wrote in message
news:GVc_h.156992$aG1.70770@pd7urf3no...
> I'm basically a database noob hoping to find a shortcut if at all
> possible.
>
> I've created an ER diagram for a site I plan to build and have used that
> to create the database in MS SQL 2000.
>
> Now I want to import various data from (basically) excel spreadsheets (for
> example, company names from a different sql dbase, addresses from excel
> and phone numbers from a csv file) into the new database.
>
> I have tried various methods outlined on web sites (including DTS) and
> have learned I need to go back and create default values for essentially
> every non-null field if I am to update literally any linked table.
>
> My question is this: Is there any easy way/program via which I can import
> the data to two different tables -- i.e. address into one table and
> corresponding city into another table -- and have the relationship(s)
> continue?
>
> Or alternatively is there a "better/easy" way to do it inside sql once I
> import the entire data into it's own single table?
>
>
>
> 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??
>
> Thanks in advance
>
>
>

[Back to original message]