Hi
I am trying to understand how to setup an import for Access that will allow me to import an excel file into Access weekly and update new and existing records.
Struggling to get off the ground, I created a test database as my real import will update many tables from one excel sheet.
Whenever I complete an update query and press run I get '0 rows will be updated'. In SQL form this is what I have done.
Code:
UPDATE Groceries, Person, Sheet1 SET Sheet1.FirstName = [Person].[FirstName], Sheet1.LastName = [Person].[LastName], Sheet1.Perishables = [Groceries].[Persihables], Sheet1.Fruit = [Groceries].[Fruit], Sheet1.Vegetables = [Groceries].[Vegetables], Sheet1.Meat = [Groceries].[Meat], Sheet1.BreakFast = [Groceries].[Breakfast];
So here I have created 2 tables Person and Groceries. I imported the excel file into sheet1, which contains one field for every field in the database. I ran update and still received a 0 to update error.
What am I missing here?