Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    72

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

    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?

  2. #2
    Join Date
    May 2007
    Posts
    23
    Use SQL DMO object to create Databases... I was doing long time ago with VB, Now I am not working on VB.. Now I am a DBA.

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    if you ever make the move to vb.net, you should use SMO, not DMO.

    DMO is deprecated with 2005.

    Another option would be to design your tables to hold your data on paper, write out the DDL in QA, then just import the data using bcp.exe

Posting Permissions

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