Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    Admit have a txt file similar:

    filed1 filed2
    aaaaaaaaaa bbbbbbbbbbbbbb
    ccccccccccccc dddddddddddddd
    .............
    yyyyyyyyyyy zzzzzzzzzzzzzz

    How to create VIA VISUAL BASIC (ADO or DAO) a new SQL Server databse?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    Do you want to create a new SQL Server database, or a new table in an existing database?

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    SQL Server database "ex novo" with table named "test" and 2 filed filed1 and filed2 with the related record in txt file..

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    I cannot find an example using VBA/VB6. Here is an example using VB.NET, you'll have to find out how to convert it to VB6 yourself:

    How to create a SQL Server database programmatically by using ADO.NET and Visual Basic .NET

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    tks Hans....
    But you know my knoledgment in VB... in vb.net and ado.net i know "Zero"
    tks in other case...

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    I'm afraid I cannot help here. You're asking a bit too much here.

  7. #7
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    no worry!
    Tks always for other help..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •