[AccessD] Create Junction Table From Existing Data

This is the approach I was leaning towards.  I've parsed many a text file in
my day and can definitely do this, but, being primarily self-taught in SQL,
I thought perhaps I was missing something basic that would be considered
common knowledge to most.



Mark



-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] 
Sent: Tuesday, April 20, 2004 7:23 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Create Junction Table From Existing Data


On 20 Apr 2004 at 17:08, Mitsules, Mark S. (Newport Ne wrote:

> I did just that to create the primary tables.  But, since I've never had
to
> do this on such a grand scale, I need assistance in generating the
junction
> table.  Here is pseudo data for clarification.  I've placed dashes to
> maintain alignment.
> 
> ID--CODE--SA--SAR--SRD
> 1---EA1---SA--SAR--SRD
> 2---EEY1--SA
> 3---EEY2--SA--SAR--SRD
> 
> ...from the data above, I need:
> PK--CODE--TYPE
> 1---EA1---SA
> 2---EA1---SAR
> 3---EA1---SRD
> 4---EEY1--SA
> 5---EEY2--SA
> 6---EEY2--SAR
> 7---EEY2--SRD
> 
> Any suggestions?
> 

I'd do it in code.
Open the old data set and step through it.
For each record, step through the fields and create a new record in 
the new table where required.

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com