Hello, I'm beginning to learn Access and I can't seem to find the answer so I think I'm approaching this in a wrong way.
I have an Excel linked table(excel table) with 4 columns.
Name, Address, Amount, ID
From this table I run an apend query to an access table (Table1) with the same columns.
This table also generates an auto number that I then copy and paste back into the excel linked table. This is so I can append the data from (excel table) to another table (Table 2)
I want to be able to retrieve the auto-generated numbers from Table 1 without having to copy-paste. Thanks!
Excel table-->table 1-->excel table(retrieve auto generated number)-->table 2
I have an Excel linked table(excel table) with 4 columns.
Name, Address, Amount, ID
From this table I run an apend query to an access table (Table1) with the same columns.
This table also generates an auto number that I then copy and paste back into the excel linked table. This is so I can append the data from (excel table) to another table (Table 2)
I want to be able to retrieve the auto-generated numbers from Table 1 without having to copy-paste. Thanks!
Excel table-->table 1-->excel table(retrieve auto generated number)-->table 2