Exporting large MEMO to SLK and opening it

[Mike Fedkiw]

This information would have been good to know a week or so ago, Lol

Anyway, now that I'm using PlanMaker 2016 to view and edit my exported 
SLK files I'm all good. I'm not doing much modifying other than moving 
cells around and figuring out how I want to organize them for importing 
the information into sixbit which I'm using to manage an eBay store.

I could care less about the SLK extension if I was able to export the 
data directly into an XLS file that I could open and edit a bit, but it 
seems the SLK is the closest I'm getting to it.


Mike



On 8/17/2017 5:21 PM, rdfreedman BellSouth wrote:
> Excel export... The format (.slk) saves only the values and formulas on the active worksheet, and has limited cell formatting. Only up to 255 characters are saved per cell. Microsoft does not publish a SYLK (.SLK) specification.
>
> I seem to remember Excel's .SLK import makes two passes, one) to count rows to reserve and two) to actually do the import... Seems the error is occurring on the first pass since data was not imported.
>
> Excel cells can contain 32,767 characters since Excel 2007.
>
> Specifications and limits for Excel 2016-2013. Excel 2010, Excel 2007
>
> https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?CorrelationId=a8d6c8f7-6047-42de-935a-5a408c46c54e&ui=en-US&rs=en-US&ad=US&ocmsassetID=HP010342495#ID0EBABAAA=Excel_2016-2013
>
> Importing .SLK files... .SLK files are limited to ASCI characters... Some characters cause import problems such as the semicolon. More info and details are here:
>
> https://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)
>
> Excel's importing routine may not like the contents of a .SLK file or the .SLK file may not be 'clean' or exceeds a 255 character .SLK cell limit.
>
> Reggie Freedman
> CPI of South Florida, Inc.
> 386-960-7073
>
>   
> ----- Original Message -----
> From: Mike Fedkiw via Filepro-list <filepro-list at lists.celestial.com>
> Reply-To: Mike Fedkiw <mfedkiwfp at gmail.com>
> To: 0 Filepro List <filepro-list at lists.celestial.com>
> Sent: 8/17/2017 3:44:00 PM
> Subject: Exporting large MEMO to SLK and opening it
> ________________________________________________________________________________
>
> I really appreciate all the reply's and help I've gotten here, I don't
> think I'd have found a suitable solution without it.
>
> Now that I have a solution to my problems exporting a MEMO to a SLK
> file, I figured I'd post what I'm doing in case It might help someone
> else out in the future.
>
> 1.  This worked to export the data export multi
> invfile=c:\!Output\eBay\eBayInvy.slk
>
> 2.  This worked to copy the MEMO data invfile(46)=""{invy(367)
>
> The above worked to export the data all along but it took me a while to
> realize it because of the errors I was seeing when trying to open the
> exported SLK file. Then after playing around a bit and doing a little
> more testing and some google searches I found out that Microsoft Excel
> will only open SLK files with 255 characters or less in a cell without
> errors. After knowing the limitations of excel I started looking around
> for a different program to open, edit, etc the SLK files and I found a
> very nice solution with "SoftMaker Office 2016 for Windows" for only
> about 50.00.
>
> I just figured I'd post this information because even if someone knows
> how to export a MEMO to a SLK file, if it happens to be larger than 255
> characters they may not know the limitations of opening that file with
> MS Excel.
>
>
> Mike
>
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170817/07fed546/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>