robmason10
Technical User
OK so its not my job but we are a bit stretched and it looks like I am going to have to do it myself - sok please excuse my ignorant terminology etc
Basically I have 5 sql tables which are linked by an auto-generated key i.e.
Table 1 [Key 1] = Table 2 [Key 1]
Table 2 [Key 2] = Table 3 [Key 2]
Table 3 [Key 3] = Table 4 [Key 3]
etc...
My data source is an excel spreadsheet were all data ofr 1 linked transaction is on 1 line - simple
So I can get my 'Insert into' etc but I don't know how to catupre [Table 1[key 1]] as it is created and pass it to [Table 2 [key 1]]
Would a sympathetic soul be prepared to point me in the right direction?
Basically I have 5 sql tables which are linked by an auto-generated key i.e.
Table 1 [Key 1] = Table 2 [Key 1]
Table 2 [Key 2] = Table 3 [Key 2]
Table 3 [Key 3] = Table 4 [Key 3]
etc...
My data source is an excel spreadsheet were all data ofr 1 linked transaction is on 1 line - simple
So I can get my 'Insert into' etc but I don't know how to catupre [Table 1[key 1]] as it is created and pass it to [Table 2 [key 1]]
Would a sympathetic soul be prepared to point me in the right direction?