使用本地数据更新SQL Server表 [英] Update SQL Server table with local data

问题描述

我有一个项目，用于在Access 2010中创建一个应用程序，该应用程序将使用本地表通过平板电脑(从中收集数据的地方没有无线网络)收集数据，然后在平板电脑回到具有无线网络的位置时使用连接性以便能够上传数据.

I have a project to create an application in Access 2010 that will use a local table to collect data with a tablet (that does not have wireless where data is being collected from) and then when they get back to location that has wireless connectivity to be able to upload the data.

我有SQL Server数据库和表.使用链接表设计应用程序，然后将它们转换为本地表，所以我知道两者的设计是相同的.

I have the SQL Server database and tables. Designed the application using linked tables, then converted them to local tables, so I know the design is the same on both.

用本地表中的信息更新sql服务器表的最简单方法是什么?

What is the simplest way to update the sql server tables with the info from the local tables?

推荐答案

可能最直接的方法是将链接表保留在Access应用程序中，这样就可以同时拥有本地表(例如[Stuff])和链接表(例如[dbo_Stuff]).当网络连接可用时，您可以使用

Probably the most straightforward approach would be to keep the linked tables in the Access application so you would have both local tables (e.g., [Stuff]) and linked tables (e.g. [dbo_Stuff]). When the network connection is available you could use Append queries and/or Update queries to copy the data from the local tables to the linked tables.

这篇关于使用本地数据更新SQL Server表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！