Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Red face Unanswered: String Field Length

    I've imported a .csv file into Crystal so I can report on it. One of the fields I'm exporting is a Notes field that has unlimited length, however Crystal is setting the field as a string with a length of 255 chars. How do I extend the field length so that Crystal reads the whole thing?
    Thanks in advance.

  2. #2
    Join Date
    Feb 2007
    Posts
    348
    I can't say I have encountered this. When I tried to do it, it worked correctly, so I may not be a lot of help.
    I would try working through an intermediate step like importing the CSV to Access so you can set the field type.

  3. #3
    Join Date
    Nov 2007
    Posts
    2
    Thanks anyway. I'm running the csv into access which does the job. Disappointed that I have to insert an additional step tho'!
    Many thanks for responding.

Posting Permissions

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