Hi, I am trying to import data from an excel 2007 spreadsheet to access 2007 table. Everything seems to work fine apart from one ERROR: my ID field is set up as a auto number and its the primary key. When i import the data the Error message states “Null value in an auto-number field”
Can anyone please help me with this???
Any help would be very much appreciated!
Thanks
Mark