Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006

    Unanswered: Need help loading data file to sql anywhere db

    I have a small sql anywhere database and try to load data from text files to the tables in the database.

    I use Interactive SQL (ISQL tools) to load data.
    for small table, the loading is fine with the "load table xxx from 'a.txt'

    However, there's one table which has about 500 columns and I always has problem to load data into the table.
    Error message said memory too large.

    Is there any suggestion to resolve the problem.

  2. #2
    Join Date
    Aug 2008
    why on earth do you have a table with 500 columns?

    maybe you should normalize that sucker

Posting Permissions

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