Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    3

    Unanswered: Transfer records from text file to SQL database

    Hey,

    I have a text file with 1000 records and 270 fields which i need to transfer it to SQL database. I want a code which can help me doing the same and not DTS.It has no delimiter.

    CAn you help me ?

    Thanx,
    Twinkle

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Are you trying to do this programmatically (using vb) or using SQL Server commands ? Try bulk insert or bcp in sql.

Posting Permissions

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