Can a Query be used to create another database?

R

Rod

Hopefully someone can help

I am trying to export certain records out of my main database into another database. The area that I am concerned with is that I would like an SQL statement to create the database first, then create the necessary tables, then append the data

Using the SQL syntax of CREATE DATABASE database_name does not appear to work in Access 2000

Is this request (1) possible, and (2) can it be done without much (or any) programming? I have no VBA experience

Ro
 
V

Van T. Dinh

There is no SQL statement "CREATE DATABASE ..." in JET SQL.

You can use the CreateDatabase Method using VBA code.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
Hopefully someone can help,

I am trying to export certain records out of my main
Click to expand...
database into another database. The area that I am
concerned with is that I would like an SQL statement to
create the database first, then create the necessary
tables, then append the data.
Using the SQL syntax of CREATE DATABASE database_name
Click to expand...
does not appear to work in Access 2000.
Is this request (1) possible, and (2) can it be done
Click to expand...
without much (or any) programming? I have no VBA
experience.
 
Top