| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
Good morning all,
We are extracting some Maxcim (rms index files) via focus with
format lotus. This is so that the extracts can be imported into
an ACCESS database via format delimited. With the majority
of files we have no problems. But some give error:
LINE LENGHT EXCEEDED, LINE WAS TRUNCATED
The resulting output file also is not readable by access.
Can anyone shed a light on this. Has anyone else had this type
of experience, are there any other formats we can use for
import into access databases?
Many thanks in advance,
Shaw
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 606.1 | workaround for FORMAT LOTUS size problem... | AIMHI::BEAUCHESNE | Fri May 26 1995 14:01 | 14 | |
Here's what I sent via mail to Shaw, anyone know of other solutions?
Shaw,
I've had the same problems with wide records - don't recall the
exact number of characters, but the way to get around this is to
hold FORMAT ALPHA. You don't get the quotes and commas, so it
takes a little more work on the MS ACCESS side, but it does work.
Basically, you'll have to tell Access the size and format of each
record, and import it as fixed width.
Moe
| |||||
| 606.2 | a work around | SALEM::DATABASEMGR | Wed May 31 1995 10:51 | 16 | |
Moe, Thanks.... I had problems with format Alpha, as datatype
conversions within access became a problem. The only way
I could bring in the data was to define all fields in the
edit spec as TEXT , however, after the import when I tried to
change the datatypes I lost the data.
So what I did was to break up the fields in two or three files
let's say mainfile has 40 fields, I extract file1, field 1
through 20, file2 field 1 and 21 through 30, file3 field 1
and 31 through 40. So now I have three tables, then run
make table query and combine the three to get mainfile as one
table, it works ;-)
Shaw
| |||||
| 606.3 | including delimiters | SEDOAS::TOMLINSON | Tue Sep 05 1995 04:41 | 10 | |
FOCUS V6.1 has a 255 byte limit on HOLD AS FORMAT LOTUS. V6.5 has a 512
byte limit.
Alternatively DEFINE some dilimiter fields, included them between the
fields being saved asn use ON TABLE SAVE. Remember to use the correct
delimiters.
Martin
| |||||