Geek Answers Handbook

Import .sql file in Access

I need to import an .sql database backup file created using MySql into Access.

Is there any way to perform this operation?

+6
sql mysql ms-access
source share
3 answers

You cannot restore MySQL backup to any other database system.

If you want to import MySQL data into Access, you can export it all to CSV files and import it into Access. You still have to recreate relationships, defaults, indexes (?), And other data.

+3
source share

You can import SQL Server data into a new Access table. In general, import is a way of converting data from another format and copying it to Access. The source table or file does not change in this process. You can import directly from a SQL Server database using an ODBC connection, a text file exported from SQL Server, or an XML file exported from SQL Server.

To make frequent import operations more convenient, you can automate them by creating a macro or by creating a Microsoft Visual Basic for Applications (VBA) procedure. This is useful, for example, when you import data on a regular schedule or you have unusual or complex requirements for importing data.

0
source share

if you are using SQL Server Management Studio, then you can open .SQL files, and this will help you figure out what syntax works in SQL and what not.

For example, if you have a table name that is spelled incorrectly, SQL Server Management Studio will give you red squigglies under that table name.

I do not see this functionality in Access, and I do not think that it will come soon. Access (Jet) has not received any new features in almost 15 years.

-2
source share

More articles:


All Articles