how to get the fast way to spool file from sql navigator

SQL files can be read by any SQL-compatible database program, including FileMaker, Microsoft Access, and MySQL. They can be edited using any text editor.

Answered Nov, 12 2010

Hello, you can try this method, maybe it helps you.

— Log in to phpMyAdmin — Click Databases — Select target database (This is the database where you want your information to go) — tables in database will appear — Click Import Tab — Click Browse and point it to backup file — Check SQL radio button — Click Go button.

Wait until it finishes running. Hopefully it will succeed.

Answered Jan, 29 2011

You don't really. You can use Access as a front end for SQL Server, but it won't run SQL commands (your .sql file) directly itself. Your options are to translate what is in the .sql to Access or create an ODBC connection from Access to a SQL engine. The SQL engine can be a server running something like SQL Server 2005 or you can run SQL Express 2005 on the same machine.

The best way really depends on what is in the .sql file. If is a simple query, you will be better off just doing the translation to an Access query. However, the .sql file could be a complex as creating a entire database including triggers, constraints, data validation, stored procs, indexes, etc- in which case you might have to run it on a SQL engine or give up some functionality in the code. Answered Dec, 10 2010