Do not use on any
shared computer
August 29, 2008 02:46pm pdt
 
[x]
Attachment Details

Importing a text file: non-fixed length, with unreliable column terminators

Zone: MS SQL Server
Tags: length, file, text, fixed, import
I'm looking for the easiest way to import a text file to a database table, where the file has the following properties.

There are 20 fields, but the length of the fields vary from row to row.
There is no reliable column terminator, as some fields are name fields which could be

     STEVE SMITH
  or
     THE STEVE SMITH FOUNDATION

I'd like to use Bulk Insert, but I don't see a simple way of doing it.

Thanks,

  JK
Start your free trial to view this solution
Question Stats
Zone: Microsoft
Question Asked By: JaffaKREE
Question Asked On: 11.19.2007
Participating Experts: 2
Points: 500
Views: 0
Translate:
Loading Advertisement...
 
[+][-]Expert Comment by cs97jjm3

Rank: Guru

Expert Comment by cs97jjm3:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by k_rasuri

Rank: Master

Expert Comment by k_rasuri:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by cs97jjm3

Rank: Guru

Expert Comment by cs97jjm3:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080723-EE-VQP-34 / EE_QW_2_20070628