HI

I have about 5,000 records (name, code, remarks) originally done under
Record Holder Plus many years ago. I have hard copy I can apply OCR to
form either .TXT files or convert to Word files.

Is there a way to import directly from either text or Word without
going through Excell?

Thank is advance for any hints.

seasons greetings, Art

Art <revs.perfins (AT) gmail (DOT) com> wrote:

You can use text if you manage replace whatever seperates your records
with carriage return and whatever seperates the fields with ";" or
something else Filemaker will read as a field seperator - check the CSV
format of your Filemaker version (this may depend on region and/or
platform).
--
http://clk.ch

"Art" <revs.perfins (AT) gmail (DOT) com> wrote

All versions of FileMaker Pro will import data from a .TXT file and many
other formats, as long as each field's data is separated by tab
(tab-delimited) or a comma (comma-delimited, also called a .CSV file). First
create a database and define the appropriate Fields, then Import the .TXT
file data via the File menu.

If the field's data is not separated, then you've got a problem. You might
have to go through the .TXT file manually separating the data.

Helpful Harry )

why not use excel or one of the many free variants?



--
-------------------------------------------------
Captain Guy
100ton-Sail-Towing-Coastal
Deliveries & Instruction-Power & Sail
New Smyrna Beach FL USA
386-689-5088
-------------------------------------------------
s/v Island Time (Beneteau 352#277)
AICW 845.5

"Art" <revs.perfins (AT) gmail (DOT) com> wrote

On Dec 20, 3:06*pm, "Your Name" <your.n... (AT) isp (DOT) com> wrote:
Hi,

I edited the text file with a tab between data fields and FMP10
responded with "This file could not be translated sing the selected
file type". Since I'm using a Mac under 10.6 I'll try creating the
file I wan to enter without an extension.

On Dec 20, 3:02*pm, c... (AT) tele2 (DOT) ch (Christoph Kaufmann) wrote:
Hi and thanks to all

Problem fixed. I went to tabs and used 8 bit coding into a three field
file. Almost back to the first computer i touched, an IBM CPC-2 back
in 1953. Maybe being in the mid-80s helps.

Thanks again and seasons greetings, Art

"Art" <revs.perfins (AT) gmail (DOT) com> wrote

Assuming you have got a proper text-only file, then I do have a vague
recollection that Mac OS X uses ".tab" as the filename extension for
tab-delimited text files. I seem to recall a while back needing to keep
changing the extension, which got annoying.

Helpful Harry )