Updating tables in sql server
Tip: Any table that has a name ending in "_local" is excluded from the list of available tables to prevent upsizing tables that have already been upsized.
If you do want to upsize these tables again, rename them before you run the Upsizing Wizard by removing the suffix "_local".
Top of section In this step, you select which table attributes to upsize to your SQL Server database.
By default, all attributes are selected for upsizing by default.
Note: By default, the Upsizing Wizard converts Access field names to legal SQL Server field names, and converts Access data types to the equivalent SQL Server data types. The Upsizing Wizard converts Access primary keys to SQL Server indexes and marks them as SQL Server primary keys.
If you choose to link the upsized SQL Server table to your Access database, the Upsizing Wizard also adds the prefix "aaaaa" to the index name.
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.
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.
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.
Search for updating tables in sql server:
Tables that are not currently visible in the Navigation Pane are also excluded, including hidden tables and system tables.