Post reply

Import string > 8000 characters

  • October 16, 2008 at 8:13 am

    #75344

    I'm using SQL Server 2000 and trying to import more than 8000 characters (one single string) into a text field. The import wizard will not allow me to change the source to something other than varchar(8000) and there is too much information in the string for Query Analyzer to run it manually. How can I get around this?

    The original text file contains this very long string that I'm trying to parse which identifies the position of other data contained within the text document. Importing the remaining data is no problem but if I can't match the data with its position title I'm screwed.

    Example:

    title string -- > a520532-00-645480-072008-4034419-64427a520532-00-645480-072008-4034419-64472a520532-00-645481-072008-4034419-64500a520532-00-645481-072008-4034419-64516 ... (10,000+ characters)

    matching data --> 22-1221122-11 ... (1024+ values)

    Thank you in advance for any advice.

  • October 16, 2008 at 9:27 am

    #885924

    Never mind, I added a suffix to the end of each title (.bk). Under Select file format set the Row Delimiter to Tab, Text qualifier to . Under Specify Column Delimiter I choose Other and utilized the .bk suffix.

    This is better than nothing.

    Thanks for looking.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply