From:       To:      
Home > Documentation > Convert Access to SQL Server FAQ

How to rename column in the resulting SQL Server database?

You can modify column name by processing table as result of the appropriate SELECT-query with alias for particular column:

    SELECT FName as FirstName, LName as LastName FROM Table1

Then store query with name of the original 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