Hello all,
Is there anyway I could import an excel spreadsheet to access to update an existing table? The table was created before and I'd like certain columns to be updated with certain rows from a spreadsheet.
Any help would be great! Thanks.
Novice
Windows 7 64bit 
Access 2007
Hello all,
Is there anyway I could import an excel spreadsheet to access to update an existing table? The table was created before and I'd like certain columns to be updated with certain rows from a spreadsheet.
Any help would be great! Thanks.
VIP
Windows XP Access 2007
Import it to a new table.
Then you can link the new table with your original table, and use an Update Query to update any columns which have changed.
Novice
Windows 7 64bit Access 2007
Joe,
Right before I saw this, i just thought of making a new table and updating it from there haha. Thanks so much for the help though!
VIP
Windows XP Access 2007
Well then, I hope I at least confirmed that you were on the right path!Right before I saw this, i just thought of making a new table and updating it from there haha. Thanks so much for the help though!
Novice
Windows 7 64bit Access 2007
Absolutely! You can take credit for this one haha
import excel sheet causes autonumber beyond records
Import excel sheet data into Ms-access using VBA macros
Posting Permissions
Reply With Quote