DBTools Software - Forums

Anonymous

Home » Forums » DBManager General

How do you convert Access table to SQL table? (1476 previews)
How do you convert Access table to SQL table?	Posted in 26th, 10/2005 07:14 by yiukori
I want to create a SQL table on a SQL server that have the same information as the MS Access table. Does anyone have any idea of how to use DBManager Professional to do that convertion? Any help will be greatly appreciate! Yiu /
Re: How do you convert Access table to SQL table?	Posted in 27th, 10/2005 09:40 by support
Hi, You can achieve this in 3 different ways, but for all of them you will need the DBManager Enterprise Edition. 1) Using the MSDAO Import Wizard: a) Connect to the MSSQL Server b) Create an empty database which will be the mirror of the MSAccess db c) Start the Wizards Manager and choose the DAO Import Wizard d) Fill all the data required e) At the end of the process you will have an MSSQL Server database with the same structure and data (if you chose to) as MSAccess db 2) Using the Migration Wizard: a) Connect to MSSQL Server b) Create a new MSAccess Server with Server Manager c) Attach the MSAccess database you want d) Start the Wizards Manager and choose Migration Wizard e) Follow the steps in the wizard 3) Using Drag and Drop a) Connect both MSSQL Server and MSAccess b) Select the Objects View c) Select the MSAccess database=>Tables item d) Drag all tables you want to the MSSQL Server database e) This will start the migration wizard to let you choose information that will be imported/converted Hope that helps, Best Regards, Support / DBTools Software
How do you convert Access table to SQL table? (1476 previews)

Legends

Topic has Replies

Topic With no Replies

Home » Forums » DBManager General