Import Process :: TEXT QUESTION

  • I’m writing an import process for a huge file and I’m having some problems. The end user wants many of the rows concatenated then placed in a TEXT field in a table. Each of the rows may only be a couple hundred characters but all combined they are way over the 8000 varchar limit. I can’t use a text local variable to hold all the data before doing my insert. Does anyone know of a way to concatenate this much data and then insert it?

    Thank you very much for your time and assistance :: MATT

  • There are several very unconfortable ways to this in the back end, which I never recommend. You will have a happier life if you concatenate those columns in the Front End.

    HTH

     


    * Noel

  • If you could give us the DDL for your input file and the tables where the data is to be stored, we might be able to give you some more specific solutions.

    There is no "i" in team, but idiot has two.

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

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