"SÁRINGER Zoltán" <kecskemetisrac@free-mail.hu> wrote in message
news:%23ykrPS38EHA.4072@TK2MSFTNGP10.phx.gbl...
> 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@free-mail.hu
> remove "-" from email address when reply.
>
>
>