Ok, everytime I get the solution to 1 problem I manage to create another problem! I'm going to post everything I'm trying to do and issues.
I have an Microsoft Access database, originally it was created in 2000 but now I'm using office 2010. I did not convert my database - I was just able to open it in the new version and edit the datbase.
I prompt the user for the excel file that they want to import - the version is Miicrosoft Excel 2010 - the data in the files is stored as formulas. I need to update a table in Access with data from the excel spreadsheet - the values only. If the record already exists in the table, I need to delete the data in the table and then append the new data from excel into the table. If the record does not exist in the table, I will append it. I have 2 key fields Quote No and Item No
The problems I have ran into so far are:
Importing from the excel spreadsheet as is (with formulas). I have a work around by copying the data into a new worksheet (using access) and pasting the values only. Then importing the new sheet (which doesn't work because of the error below)
Different versions of Microsoft Excel and Microsoft Access - Microsoft Excel is a later version than Microsoft Access - which I don't understand because I'm editing my database in 2010.
I hope this makes sense! I'm at my wits end!