| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto insert of a pivot table? | Excel Worksheet Functions | |||
| Pivot Table Refresh - Auto insert row | Excel Discussion (Misc queries) | |||
| Insert Literal in Access Table using JETSQL | Excel Programming | |||
| Is it possible to insert an Access Table object into Excel? | Excel Programming | |||
| Is it possible to insert an Access Table object into Excel? | Excel Programming | |||
Threaded Mode
