create sql database from txt file via visual basic (6.0)

[luca90]

Admit have a txt file similar:

filed1 filed2
aaaaaaaaaa bbbbbbbbbbbbbb
cccccccccccc dddddddddddddd
.............
yyyyyyyyyy zzzzzzzzzzzzzz

How to create VIA VISUAL BASIC (ADO or DAO) a new SQL Server databse?
... in effect i want to create a database and table with 2 fileds and import data from txt file "ex novo"...

found thsi but vb.net and ado.net:

http://support.microsoft.com/kb/305079

[si_the_geek]

The method is very similar... the SQL string is the same (tho I presume you want different fields etc, so see the SQL tutorials in our Database FAQs), you just need to connect to the database (and execute the query) using the usual syntax.

Using ADO, that could be:

    Dim myConn As ADODB.Connection 
    Set myConn = New ADODB.Connection 

    myConn.Open "Driver={SQL Server};Server=(local)\netsdk;" & _
                                                    "uid=sa;pwd=;database=master"

    str = "CREATE DATABASE ... "

    myConn.Execute str

    myConn.Close
    set myConn = Nothing

Note that this is not a ideal example - you should add error handling etc.

[Hack]

And, even though the code is for .NET, you can use the CREATE DATABASE query from that example as a starting point for setting yours up.

[luca90]

The method is very similar... the SQL string is the same (tho I presume you want different fields etc, so see the SQL tutorials in our Database FAQs), you just need to connect to the database (and execute the query) using the usual syntax.

Using ADO, that could be:

    Dim myConn As ADODB.Connection 
    Set myConn = New ADODB.Connection 

    myConn.Open "Driver={SQL Server};Server=(local)\netsdk;" & _
                                                    "uid=sa;pwd=;database=master"

    str = "CREATE DATABASE ... "

    myConn.Execute str

    myConn.Close
    set myConn = Nothing

Note that this is not a ideal example - you should add error handling etc.

hI all
Tks for sugestion.
My friend suggest me to use SQL DMO object in VB to create database and table, wath you think?
In other case admit i have created a db and table how to insert value from txt into the new sql database?


...

[si_the_geek]

SQL DMO is certainly a valid option - but I'm afraid I can't help you with that, as I don't use it myself (so the code works for other DBMS's, I've only ever used Create statements, or occasionally ADOX).

To add data once the table have been created, use the usual methods - if you are using ADO, there are examples in this FAQ article.