Recent content by TimJC

I've found a very similar query on another forum. The answer suggested there is that when you have an autonumber field you have no option but to name the fields that you are updating. That's a bit disappointing but if that's the way it is, that's the way it is (unless you know better!):banghead:

Hello all. I am just beginning to manipulate Access from Excel. I am trying to insert a row into a table. I am adding values for every field (8) except an Autonumber. I have 2 Insert strings which are identical except for the fact that the one that doesn't work, doesn't specify which...

I think you are right David! I have no idea how they got there. I presume I must have clicked a smiley somewhere by mistake,

After about a day and a half of frustration with this I finally managed to get it to work by stripping everything out of the connection string except the provider and source details. Now on to the mysteries (to me) of recordsets.

Hello All. I have a 1 table (at the moment) Access 2007 database with 150 records. When I try to import the records to Excel 2007 using the "From Access" option on the Data tab I have no problem at all. However when I try to do the same thing from within VBA my sub breaks down with the...