To generate a nicely formatted display for this purpose, you can pass the // Load and parse the JSON var some JSON = /* Omitted: fetch it from the server however you want */; var parsed = JSON.parse(some JSON); // Update view model properties view Model.first Name(parsed.first Name); view Model.pets(parsed.pets); In many scenarios, this direct approach is the simplest and most flexible solution.
As you might have guessed, the first approach is not feasible especially in cases where you have humongous volume of data in your source table whereas in case of the second approach you need to have some mechanism to identify the changed data set in the source table after the last data pull so that only those changed data sets can be considered while pulling it from the source table and to load into the data warehouse.
Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.
As you proceed, remember that updating data is not the same process as entering new data.
In turn, those design principles affect how you enter data.
Remember these facts about database objects and design as you proceed.