Re: simple Excel import to master-detail tables

#1

Hi,
Probably you can use lookups...
http://www.sqldts.com/default.aspx?277
Rgds
JFB

"SÁRINGER Zoltán" <kecskemetisrac (AT) free-mail (DOT) hu> wrote

Quote:

Hello,

I have a similar excel sheet:

company_name site_name
CompA site1,site2,site3
CompB site4,site1
CompA site5
...

I want to transform into sql "company" and "site" sql tables. (each tables
have uniqueidentifier ID column and the "name" column)
company: ID, name
site: ID, company_ID, name

the transform should do:
- automatically insert detail table rows: insert company_ID too
- do not allow duplicates of companies (by Index constraint, or how?)

If it is simplier to do it by ActiveX script, it would be better... just
send me an example, please!

--
kecskemetisrac (AT) free-mail (DOT) hu
remove "-" from email address when reply.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: simple Excel import to master-detail tables

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: simple Excel import to master-detail tables - 01-05-2005 , 10:07 PM