Results 1 to 2 of 2

Thread: Import Text Files

  1. 08-30-1999, 05:58 AM #1
    Pedro Santos Guest

    Import Text Files

    Hi ppl,
    I'm trying to import a fixed lenght text file into a sql 7.0 table using the SQL command "BULK INSERT".

    The text file is fixed length and end with a carriage return and linefeed. Fields aren’t delimited.

    Wich definition of the "FIELDTERMINATOR" should i use ?

    I need some Help here!!!
    Thanks.

    Reply With Quote Reply With Quote
  2. 08-30-1999, 11:05 AM #2
    John Helton Guest

    Import Text Files (reply)

    In SQL Server 6.5 I use



    ------------
    Pedro Santos at 8/30/99 6:58:15 AM

    Hi ppl,
    I'm trying to import a fixed lenght text file into a sql 7.0 table using the SQL command "BULK INSERT".

    The text file is fixed length and end with a carriage return and linefeed. Fields aren’t delimited.

    Wich definition of the "FIELDTERMINATOR" should i use ?

    I need some Help here!!!
    Thanks.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules