General discussion

  • Creator
    Topic
  • #2074544

    Save as Lotus wk1 from Excel loses info

    Locked

    by seafitch ·

    Using ODBC I have imported a file containing over 29,000 lines sucessfully into Excel. In the save as .wk1 I only get 8,192 lines. Does anyone have a workaround? I am in the process of converting to a new software system and if I could convert the data directly it would save time.
    Thanks in advance
    Sarah

All Comments

  • Author
    Replies
    • #3778369

      Save as Lotus wk1 from Excel loses info

      by miked ·

      In reply to Save as Lotus wk1 from Excel loses info

      8192 is the max numbers of rows in a wk1 spreadsheet. Why are you using wk1? If it is for an old version of lotus then check to see how many lines your version will allow (it might be 8192, 16386 or more.

      If you are looking for a more ‘portable’ file format, try ‘csv’. As long as there are no formula to transfer, you should be OK.

      • #3783904

        Save as Lotus wk1 from Excel loses info

        by seafitch ·

        In reply to Save as Lotus wk1 from Excel loses info

        Needed to import from VMS system into Lotus and massage with Q&A to export fixed ASCII for new software vendor who can’t use straight Excel format. Thanks for confirming limitation of Lotus.

    • #3777097

      Save as Lotus wk1 from Excel loses info

      by dl.goss ·

      In reply to Save as Lotus wk1 from Excel loses info

      have you tried “exporting” the data into something like a comma delimited text file and then importing it into lotus? this may be a suitable work around and in addition gives you a back uo of the file in case you have any problems?

      • #3783905

        Save as Lotus wk1 from Excel loses info

        by seafitch ·

        In reply to Save as Lotus wk1 from Excel loses info

        Can’t use commas as we have commas in data and they are used as field delimiters on the receiving end.

    • #3776767

      Save as Lotus wk1 from Excel loses info

      by m42 ·

      In reply to Save as Lotus wk1 from Excel loses info

      No way to export over 8192 lines of data to .wk1 files. That’s a limit by design of the file format.

      Workarounds:
      – Export as .csv and then import to whatever you want (loose formulas, graphics, formats, etc..)
      – Why are you wanting to export as .wk1 ? if the software supports it try .wk3 or other common format with more capabilities than .wk1
      – Why not import directly into the final system with ODBC ? If its a well-known system it must have an ODBC driver available somewhere…

      Good Luck

Viewing 2 reply threads