Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Overcoming .csv export limitations?

    I'm exporting a query to a .csv file. The memo fields are getting cut off at 255 characters in the export file? is there a way to overcome that? i've looked into creating a schema.ini file, but cant figure out how to use it after its created.
    Ane help is greatly appreciated.

    Thanks,
    d

  2. #2
    Join Date
    Jul 2003
    Location
    Portugal
    Posts
    111
    Sorry my question, but...

    are you sure that is a memo field? Has that field a memo definition in the table? It sounds a normal text field in the max char lenght...

    Ruas

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    All memo fields (3 of them)
    All show up fine in the query / forms / etc.
    Only truncated on export.

    A schema file was created in the folder of the export and it sets the Width of all these files to 255. I've tried editing the scema.ini file, but dont know how to get access to recognize/use it when exporting.

Posting Permissions

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