Hi,
Im quite new to MS Access. Recently Ive been trying to import an excel sheet into an MS Access database and append 100s of records from excel to access(doing from the front end GUI is a pain in the neck for my team).But there seems to be a primary key violation everytime I try to import the data from excel. Ive created a set of fields in excel to match the ones in the database(including a unique primary key id,which generally is autogenerated in the database),but the value I have in the primary key field in excel doesnt seem to be accepted by the primary key field in the database. I keep getting a primary key/indexing error.Is there a way I could copy the data into access by say, deactivating the primary key constraints for a while to allow the values Im inserting from the excel sheet? Any help on this will be highly appreciated...
A. Nair
Im quite new to MS Access. Recently Ive been trying to import an excel sheet into an MS Access database and append 100s of records from excel to access(doing from the front end GUI is a pain in the neck for my team).But there seems to be a primary key violation everytime I try to import the data from excel. Ive created a set of fields in excel to match the ones in the database(including a unique primary key id,which generally is autogenerated in the database),but the value I have in the primary key field in excel doesnt seem to be accepted by the primary key field in the database. I keep getting a primary key/indexing error.Is there a way I could copy the data into access by say, deactivating the primary key constraints for a while to allow the values Im inserting from the excel sheet? Any help on this will be highly appreciated...
A. Nair