<html><head></head><body>Actually a CSV file is where I started with a different export but I just couldn't get it to work because of asterisks, commas and semicolons within the field I wanted to export. That's why I went to the SLK file, it didn't care about any of that. I think it's kinda ridiculous that it can be so difficult to export stuff like I'm trying to. It's like use slk for this one but use something different for another and I haven't really done much exporting anyway. Can't wait until I need to find a third way to export something, this just sucks. <br clear="none">
<br clear="none">
Mike <br clear="none"><br clear="none"><div class="gmail_quote">On Jul 19, 2014, Terry Graham <terryg@tlgsb.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k10mail">I wouldn't use a .slk file which has lots of Excel parameters. Just use <br clear="none">a .csv file. I do it all the time.<br clear="none"><br clear="none">Terry Graham<br clear="none"><br clear="none"><br clear="none">On 7/19/2014 4:11 PM, Mike wrote:<br clear="none"></pre><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">I have created files just like this in the past but every time I create<br clear="none">one from this file, it has tons of errors when I try opening it with<br clear="none">excel2003. This is a simplified processing table and it still getthe errors.<br clear="none"><br clear="none">This is exactly what the errors say<br clear="none"><br clear="none">cannot read record 688114.<br clear="none">continue reporting each error?<br clear="none"><br clear="none">Microsoft office excel cannot convert some of the cells. The total<br clear="none">number of errors found is 68811
4<br
clear="none"><br clear="none">There's only 42,187 records in the file<br clear="none"><br clear="none">I also ran a process to clean up any junk or empty records while copying<br clear="none">the good ones into a new file. I also turned on the browse and scanned<br clear="none">through the records but didn't see any garbage within it<br clear="none"><br clear="none">this is ole line of what the data looks like<br clear="none">10001310 0025 10004567<br clear="none">each of those is a separate column within the output file<br clear="none"><br clear="none">I just don't get it<br clear="none"><br clear="none"><br clear="none"><br clear="none">start ? If: 1 eq ""<br clear="none">Then: end<br clear="none">2 ------- - - - - - - -<br clear="none">? If: 26 eq ""<br clear="none"><br clear="none">1. Then: end<br clear="none"><br clear="none">3 ------- - - - - - - -<br clear="none">? If: 8 eq ""<br clear="none">Then: end<br clear="none">4 ---
----
- - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: export multi disfile=c:\export\discfile.slk<br clear="none">5 ------- - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: disfile(1)=1<br clear="none">6 ------- - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: disfile(2)=26<br clear="none">7 ------- - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: disfile(3)=8<br clear="none">8 ------- - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: end<br clear="none">-------------- next part --------------<br clear="none">An HTML attachment was scrubbed...<br clear="none">URL: <a shape="rect" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20140719/fe8e8fd3/attachment.html">http://mailman.celestial.com/pipermail/filepro-list/attachments/20140719/fe8e8fd3/attachment.html</a><br
clear="none"><hr><br clear="none">Filepro-list mailing list<br clear="none">Filepro-list@lists.celestial.com<br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a></blockquote><br clear="none"><br clear="none"></blockquote></div><br clear="none">-- Sent with <b><a shape="rect" href="https://play.google.com/store/apps/details?id=com.onegravity.k10.pro2">K-@ Mail</a></b> - the evolution of emailing.</body></html>