Write data to Access table with INSERT when table has auto number
I want to write Excel table data to an access table using INSERT but need to
skip the first field because it has datatype 'AutoNumber' which doesn't
accept bing written to. Below is where I'm at, trying to write nothing (i.e.
' ') to the first field in the Access Table where the AutoNumber data type is
defined.
sSQL = "INSERT INTO tblTest VALUES ('','CatD8N', '4.5', '4', 'RMM1',
'10/10/2005', 'Comemtn 1');"
cnAccess.Execute sSQL
|