Importing text files into SQL using VB


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Importing text files into SQL using VB

  1. #1
    Gerald Guest

    Importing text files into SQL using VB


    Hi Everyone

    I am trying to import a comma delimited txt file into a SQL Server 7.0 table
    - I am using VB6 as the front end and ADO as the connection type. The text
    file name varies each day but basically all it has to do is be dumped into
    the SQL table.

    I've tried using BCP and "importdata" but I can't get hold of any sample
    code that clearly shows what to do. I would greatly appreciate any help
    from anyone.

    Thank you

    Gerald

  2. #2
    Omar Guest

    Re: Importing text files into SQL using VB


    Your best bet is by using DTS. There is a wizard in SQL 7.0 that
    will help you build the process.

    "Gerald" <geraldd@spearion.com.au> wrote:
    >
    >Hi Everyone
    >
    >I am trying to import a comma delimited txt file into a SQL Server 7.0 table
    >- I am using VB6 as the front end and ADO as the connection type. The text
    >file name varies each day but basically all it has to do is be dumped into
    >the SQL table.
    >
    >I've tried using BCP and "importdata" but I can't get hold of any sample
    >code that clearly shows what to do. I would greatly appreciate any help
    >from anyone.
    >
    >Thank you
    >
    >Gerald



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center