Updating excel from access
Ideally I will have the macro being able to only append the existing list of files in the spreadsheet and do that in different color (i.e red) Is this possible and can anybody help me create the core of this macro? Paul Anything is possible Paul, maybe difficult but possible... I will send over to Access for a closer look:-) Hope you get this one pinned down.I would post a bit of anything if you have it just to give folks out there some idea what you're up against. @mdensana Hello mdensana, I'm a little confused as to what exactly you are requesting, and as to whether you wish to implement the functionality from within Access or Excel.Switch to Datasheet view to verify that the calculated date is correct (see Figure 1). Save the query as “q Up_Import_Date Order.” Run it.A message will appear asking if you want to update 6 rows. Open the import Orders table to verify that the data has been updated.
When all the worksheets are imported, you should have 368 records in the table. This is an Excel question unrelated to Access, but we are the best people to help. That sorted, I think Chip has the right idea here (and probably ADezii too as far as the specifics of the code goes).However, a clearer representation of exactly what is required would be beneficial to all. Exactly what you require is essential before we can guide you further with any assurance. Your code is still the best suggestion so far ;) I think we need a better explanation of the question before going any further though, as there is always the danger of wasting time going off in the wrong direction, which just confuses everything for later on.After establishing the proper data structure for importing data from Excel, the next step is to import the actual data.
A process using append and update queries can help you combine multiple Excel worksheets into one table in Access and update the data appropriately.
(If that isn’t visible on the ribbon, you may need to click on the New Data Source drop-down button and select From File, Excel.) This launches the Get External Data wizard.