I am transferring data from one of my MDB tables into another (originally imported from a csv).
The code I have works, except it only moves over the data from the first record. For example, if I have three records to move over, it only sends one over. What's wrong with this?
Currentdb.Execute "INSERT INTO tblInput([Field1], [Field2]) SELECT [Field1], [Field2] FROM tblTransfer
Currentdb.Execute "DELETE * FROM tblTransfer
where tblTransfer is a temp table where values are held until completion of import.