Alternatively, you can double-click a table to move it from one list to the other.
The Available Tables list includes all linked tables except for SQL Server tables already in a SQL Server database.
In addition, you explore common business motivators for determining which option works best for your application.
Azure SQL Database is a relational database-as-a-service (DBaa S) hosted in the Azure cloud that falls into the industry categories of .
In this step, you select the Access tables that you want to upsize to the SQL Server database.
Select the tables that you want to upsize, and then use the arrow buttons to move them to the Export to SQL Server list.
Over time, most database applications grow, become more complex, and need to support more users.
A requirement arises in many systems to update multiple SQL database rows.Linked tables that point to a SQL Server database that has been selected for upsizing automatically appear in the Export to SQL Server list box and can't be removed.Tables that are not currently visible in the Navigation Pane are also excluded, including hidden tables and system tables.Describes the database application programming interfaces (APIs) that support options for updating data at the current position of a result set.Transact-SQL server cursors also support updating data at the current row of a cursor.