From:       To:      

Microsoft SQL to Access FAQ

[Product's Homepage]  [Download]  [Buy]

On this page you can find the most frequently asked questions regarding MSSQL-to-Access converter. If your question is not answered here, please contact us via Feedback Form

What kind of Microsoft SQL data is converted into MS Access format?
MSSQL-to-Access converts table definitions with all necessary attributes, records and indexes. It does not convert triggers, foreign keys and stored procedures. Demo version converts only 50 records per table.
Go to Top

What are system requirements of MSSQL-to-Access?
The product requires Microsoft SQL environment (server or client components of MS SQL must be installed on the same machine where you run MSSQL-to-Access from) and installation of Microsoft Access. ODBC drivers or any other middleware is not required.
Go to Top

What versions of Microsoft SQL server and MS Access are supported?
MSSQL-to-Access works with all versions MS SQL including Azure SQL. The program can generate output in one of the following formats: MS Access 95/97, MS Access 2000 and MS Access 2007/2010.
Go to Top

How can I rename column name in the resulting MySQL database?
You can modify column name converting contents of the corresponding table as result of SELECT-query. See Using Queries article for the further information.
Go to Top

Does MSSQL-to-Access support automation?
MSSQL-to-Access converter does not support automation directly. However, there is console version of the program m2sagent.exe in the installation directory. It supports command line arguments and can be called from any script. So, it is possible to write a simple batch script and execute it recurrently using Windows Task Scheduler. Please refer to 'Command line' article of the product documentation to learn more about m2sagent.exe.
Go to Top

All table names include schema name as a prefix. How can I avoid it?
By default the program lists all tables found in the database. Because different schemas could contain tables with the same name, MSSQL-to-Access compose full table name as [schema name].[table name] to guaranty that it is unique. If you need to work with tables owned by the user specified, select "View tables owned by the user" checkbox on "Select Databases" wizard page. This will force the program to not include schema name as prefix.
Go to Top

How to change destination table name?
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 it with the name you wish to assign. Of course, you need to place actual Microsoft SQL table name in the query above.
Go to Top

Is it possible to connect to Azure SQL from MSSQL-to-Access?
Yes, it is possible. See How to connect to Windows Azure SQL article for related information.
Go to Top

I don't see all tables of the database. Why?
Please check "View tables owned by the user" checkbox on "Select Databases" wizard page. When it is selected the program only displays tables owned by the specified user. To view all tables of the database you should unselect this checkbox.
Go to Top

How to uninstall MSSQL-to-Access converter?
If you need to remove MSSQL-to-Access product from your computer, you can use "Add or Remove Programs" option in the Windows Control Panel.
Go to Top