Re: [SQL] multi table import from 1 denormalized source table

On 2010-11-16, Andreas wrote: > Hi, > > I frequently get tables from spreadsheets to import into the DB. > > Usually it looks like this: > A1, A2, A3, A4, B1, B2, B3, with optional C1, C2, D1, D2, ... > > and there is a 1:n relation between A and B. > If provieded the C would be 1:1 to A and

[SQL] multi table import from 1 denormalized source table

Hi, I frequently get tables from spreadsheets to import into the DB. Usually it looks like this: A1, A2, A3, A4, B1, B2, B3, with optional C1, C2, D1, D2, ... and there is a 1:n relation between A and B. If provieded the C would be 1:1 to A and D 1:1 to B. Up until now I let a VBA script