Script Examples vbscript autoit php batch

vbscript to create access mdb database and tables


how to create a Access (mdb) Database and tables in vbscript

create db
create a database file at "c:\test.mdb"

Dim objADOXDatabase
Set objADOXDatabase = CreateObject("ADOX.Catalog")

'Create the database file
objADOXDatabase.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                       "Data Source=c:\test.mdb"


create table
Create a table called "daten" in the database file "c:\test.mdb":

'Create table
Set objConnectionA = CreateObject("ADODB.Connection")
objConnectionA.Open _
   "Provider= Microsoft.Jet.OLEDB.4.0; " & _
       "Data Source= c:\test.mdb"
objConnectionA.Execute "CREATE TABLE daten(" & _
   "Spalte1 TEXT(50) ," & _
   "Spalte2 TEXT(100) ," & _
   "Spalte3 TEXT(100))"
objConnectionA.Close
<<< Computer Member of AD Group vbscript to read and write or update an Access mdb database >>>


neue Themen

Stichwortsuche auf dieser Seite:
11.03.2010 03:13 zZ 6 Leser online
Powered by cms.libe.net 2004-2010