How to change destination table name in Access to SQL Server converter?

You can convert contents of the table as result of SELECT-query with custom name. Click "Add Query" button on "Select tables" wizard page and compose simple query as follows:

SELECT * FROM <original table name>

Then store the query with new name and it will appear in MS SQL database as a regular table. To access this feature click "Add Query" button on "Step 4 of 5" page of the conversion wizard.

See Using Queries article for the further information.

Have more questions? Contact us