Script Examples vbscript autoit php batch

vbscript - Access (mdb) Datei generieren

(1)
Artikel bewerten
(6)

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
<<< User Member of AD Group vbscript - lesen, schreiben oder updaten einer Access Datei >>>


neue Themen

Stichwortsuche auf dieser Seite:
05.02.2012 10:27 zZ 9 Leser online
Powered by cms.libe.net 2004-2012