From:       To:      

Home > Documentation > MS Access to SQL Server > FAQ

How to rename column in the resulting Microsoft SQL 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