General discussion

Locked

Save as Lotus wk1 from Excel loses info

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

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Save as Lotus wk1 from Excel loses info

by miked In reply to Save as Lotus wk1 from Ex ...

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.

Collapse -

Save as Lotus wk1 from Excel loses info

by seafitch In reply to Save as Lotus wk1 from Ex ...

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.

Collapse -

Save as Lotus wk1 from Excel loses info

by dl.goss In reply to Save as Lotus wk1 from Ex ...

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?

Collapse -

Save as Lotus wk1 from Excel loses info

by seafitch In reply to Save as Lotus wk1 from Ex ...

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

Collapse -

Save as Lotus wk1 from Excel loses info

by m42 In reply to Save as Lotus wk1 from Ex ...

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

Collapse -

Save as Lotus wk1 from Excel loses info

by seafitch In reply to Save as Lotus wk1 from Ex ...

they are a small company and not overly familiar with the ODBC portion of their own system.

Back to Windows Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums