[AccessD] Create Junction Table From Existing Data

I have admittedly been using pseudo names for the actual data, there will be
in fact, several more fields in this query resulting in a rather large union
query.  In the event that I run into problems, is there anyone who would
volunteer to look over my actual query structure?



Mark


-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] 
Sent: Wednesday, April 21, 2004 8:03 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Create Junction Table From Existing Data


On 21 Apr 2004 at 7:53, Mitsules, Mark S. (Newport Ne wrote:

> 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.
> 
> 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.
> 

Having seen a couple of other responses and thought about it a bit 
more,  I wouldn't do it this way now. Using three UNIONed queries  
into an empty table with a predefinded Automnumber field is simpler.







 
-- 
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