VBA SQL Create database and table

[Per9922]

Hello all,

I really need the help from you! I would like to do the following from a VBA script:

1) Create an SQL database with UID=User and PWD=Password
2) Include a table in the database

I have serached the forum but I can not find anything

Please help!

Per

 

[dhookom]

Have you searched the web on "Create SQL database"?

Duane
Hook'D on Access
MS Access MVP

 

[Per9922]

Yes, but I can not find any good example....

This does not work, how to create the connection string ? How to create the tables ?

Dim str
Dim conn, rst
Set conn = CreateObject("ADODB.Connection")
conn.ConnectionString = "Provider=MSDASQL;DSN=WINCC;UID=;PWD;"
conn.CursorLocation = 3
conn.Open

str = "CREATE DATABASE MyDatabase1"
Set rst = conn.Execute(str)

 

[dhookom]

There is a good reference on connection strings.

You should first test the connection with an existing database and table on the server to make sure you can at least connect. Then you add creating a database. And then once these have all been executed successfully you attempt to create a table. Baby steps.

Duane
Hook'D on Access
MS Access MVP