I need to be able to import data from some excel spread sheet data into some individual fields of a table. Is there a way to do that assuming I have the same field names?
I need to be able to import data from some excel spread sheet data into some individual fields of a table. Is there a way to do that assuming I have the same field names?
The smartest way is to import the excel sheet to a temp table and then do an update query or append query depending on your situation to the original table.
How do you retrieve the temporary table? All it allowed me to do is search for a file in my computer and then not choose any tables.
Also, its not that I will be adding new entries, but rather I'm trying to occupy some exisiting empty cells
To import an excel file to Access using AC2010, on the ribbon, select Data, on the Data Tab, select Import. Select Excel and follow the wizard.
Seeing your last post, you are looking to update selective records? Are there many? Are they in a sequential order? You may have to fix/update manually or import all the records all over again. Without seeing your db, it is difficult to determine the proper route for you to take.