Create Access database with VB

[Mat]

Hi, I'm fairly new in using access...

I have a text file that I want to convert into a mdb file with VB, I know how to do it directly in Access, but I want to do it from a vb application...

The first line is the headers, and the column separator is the ";"

Is there a simple way of doing it ?

thanks

 

[anvil19]

Hi Mat

This code will add a new MS Access database called Mat in the root directory:

Sub CreateDatabase()

    Dim cat As New ADOX.Catalog
    cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Mat.mdb"

End Sub

You need to add a reference to the "Microsoft ADO Ext.2.1 For DDL and Security" library.

To create a new table in your new database and add data from a text file requires a lot of work with code to add the table, the columns (with data typing), Primary Keys, Foreign keys, Indexes and to Append all these objects to the new database. It's really not worth the effort if you already have Access on your machine.

If you really, really want to do so then read up on the ADOX library. All the methods are available there.

Try that

anvil19