I will be using VBA to import a large quantity of data from excel to access.
Let us say, that I have two tables which I need to write the data into:
tblMain with two fields:
uid (auto numbering)
Titel (text)
tblSub with three fields:
uid (auto numbering)
MainUid (number)
Text (text)
The number in 'MainUid' in 'tblSub' should be identical to the number given when writing data to 'tblMain' (hope this makes sense
).
My question then is - is there an easy way to get the number issued to the field 'uid' in 'tblMain', without having to run a 'select' query?
/Soren
Let us say, that I have two tables which I need to write the data into:
tblMain with two fields:
uid (auto numbering)
Titel (text)
tblSub with three fields:
uid (auto numbering)
MainUid (number)
Text (text)
The number in 'MainUid' in 'tblSub' should be identical to the number given when writing data to 'tblMain' (hope this makes sense
).My question then is - is there an easy way to get the number issued to the field 'uid' in 'tblMain', without having to run a 'select' query?
/Soren
