In the 1980's I had to import a huge file from a "wonderful" system that
wouldn't talk to any other application, and had no export capabilities.
It could save a report (with page headings and all) meant for 17"
printers. The report was huge. It was the logs from the equipment
working in a coal mine, and we needed to extract the information of how
much rock was moved and how much coal from which location was stockpiled
at each of other locations. Every trip a mine truck made from each
shovel or loader to a stockpile was in their somewhere.
I created a table with a single text column slightly wider than the
widest data row, created a form with a single field. I imported the data
using the form, then deleted any records that did not have specific
characters at the beginning of the data row/line to get rid of the page
titles and other non data rows.
I did this in 2.11 over a rather slow network with 1980's computer
capacities. It took about 2½ hours to import the data and create the
stockpile totals, but it did the work.
Albert
On 2016-10-23 1:38 PM, Gary Randall wrote:
Hello All,
I am trying to import data from a tab-delimited format txt file. I
have tried using the File Gateway utility and the command [Gateway] at
the R: prompt. When using the utility, it will not read the file, when
it comes to the step to match source column with target column the
source is empty. When using the R: prompt I get this error: “An error
was encountered during execution. Make sure the source exists and is
not locked.”
I have checked the file with excel and note it’s not locked or
corrupt. Not sure what I am doing wrong?
Thanks
Gary Randall
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
