I have to append a bunch of records (comma delimited file) to an existing populated table. One of the fields in the incoming file is an auto number field. Do I populate the auto number in the file or will ACCESS (2003) populate it for me.
tia
Code/
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("ELUR1")
intNumbRows = rst.RecordCount
/Code
intNumbRows contains one less than the actual number of rows in the table. What am I doing wrong?
tia
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.