Importing ASCII files

[AudioFreak]

Hi,

We recently purchased a biometric time clock EC205FP. The interface on this thing looks like it was made in 1950. So DOS looking it is sad. I'm considering setting up a filemaker database to put the info into instead of using the DOS looking thing they have.

The information is downloaded off the time clock via our network as a ASCII file. Then imported into their DOS looking database.

Question: Is it possible to import the ASCII file into a Filemaker database?

This would be so much nicer then the current interface we are forced to use. I all ready have a Production time database that could be used for this if I can import the ASCII file into it.

Can this be done or am I stuck in DOS interface land?

Thanks, Michael

[BobWeaver]

It should be possible to import an ASCII file. How easy it is will depend on the data format of the file, but there is always a way.

[AudioFreak]

Bob,

Thanks for the reply. Knowing this can be done I will now look into how the file is a actually formatted.

Thanks,

Michael

[AudioFreak]

Hello,

This may or may not be relevant to other ASCII files but works on the file I have.........I did learn today that by right clicking on the ASCII file and selecting open with and choosing Filemaker it automatically creates a Filemaker database with all the information parsed into seperate fields, columns, and records(Way Cool). I did not know about this and thought I would share this with everyone here.

Michael