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