<br><br><div class="gmail_quote">On Mon, Jun 10, 2013 at 3:27 PM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>On 6/10/2013 3:18 PM, Ian Wood wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
filePro 5.07.03<br>
Windows 2008 Server<br>
</blockquote></div>
[...]<div><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
After some digging, I found that the sent faxes reside in a directory<br>
called C:\ProgramData\Microsoft\<u></u>Windows NT\MSFax\ActivityLog\ in a file<br>
called OutboxLOG.txt<br>
<br>
It has a schema.ini that shows:<br>
</blockquote></div>
[...]<div><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
My conundrum is this:<br>
<br>
This looks like a regular text file with a header record and 50 fields.<br>
<br>
I have tried:<br>
<br>
import ascii imp=(file_name) r=\n f=\t<br>
<br>
import ascii imp=(file_name) r=\n f=\t o=" c="<br>
<br>
import word imp=(file_name)<br>
<br>
import word imp=(file_name) r=\n f=\t<br>
<br>
all give me the same issue, imp(1) shows only the first double quote of the<br>
file and imp(2) is blank<br>
<br>
file_name is defined as (255,*,g) and is fine.<br>
<br>
If I open the .txt file in Excel or Access it imports fine. I can then<br>
save as a .csv and run my import into filePro without issue (o post to a<br>
filePro faxlog file).<br>
<br>
I need to avoid that step as I want to automate this process nightly.<br>
<br>
I have done literally 10's of thousands, if not hundreds of imports/exports<br>
in my filePro career, so I definitely don't think it's that :)<br>
<br>
As these are standard Microsoft files, I was wondering if someone else had<br>
perhaps come across this, and if so, what they did to resolve it.<br>
</blockquote>
<br></div>
Any chance you can attach the first few lines of that file, so we can see what's actually in it?<br>
<br>
Also, when you import it into Excel or Access, what options do you use?<span><font color="#888888"><br></font></span></blockquote></div><br>To answer the second part of your question, I just take the defaults, delimited file, tab delimited, I don't even convert all columns to text, I leave them as General. <br>