🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.perl.misc
Article #62

Re: FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL

#62
From: Jesse
Date: Fri, 31 Jul 1998 00:00
43 lines
3091 bytes
I gave access a try, and had real problems.  years ago I did some
queries, scripts, etc in paradox for dos (?3.0?) so had some experience
with import/export etc.

just nothing seemed to work.  I'd set up a relationship, but the queries
seemed very hard to set up.  then I'd get the data, but it struck me as
hard to export as tab-deliminated for some reason, don't recall.

fmp is nice and "gui", looks great.  I just don't understand why they
use a "file" system, why not just use tables, queries like the rest
of the world?  just creates confusion, IMHO

normally I don't cross-post, but this is a follow up.

--
Jesse
jcs.ng@asu.edu

Ken Hince Jr wrote:

> I use both ACCESS and FMPRO, and to export between them I use the "tab
> separated text" file format. It works ok, but if you are importing into
> a new database table then you lose the names of the fields. If its an
> existing table there is no problem. You don't even have to have the
> fields in the same order in both databases because FMPRO lets you
> specifyt the order on both import and export. ACCESS probably does too,
> but I haven't made sure of that. Note that ACCESS defaults to exporting
> using the "comma separated value" format, which FMPRO can also read, so
> you could try that as well.
>
> Ken
>
> Carlos Hertel wrote:
>
> > I am looking for some information about using the application
> > FILE MAKER Pro from Clarence in connection with MS ACCESS and / or
> > MS EXCEL (esp. import/export of Data between these apps)
> > Is there any manuals, or guides concerning this subject ?
> > please write to carloss70@hotmail.com
> >
> > Many thanx in advance !
> >
> > :-)  Carlos
Technical Details
Message-ID: <35C2111B.7B1CF45F@asu.edu>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <35b34732.0@news.munich.netsurf.de> <35BD7ADA.CC1347A5@ozemail.com.au>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fe428,a829c3e5e099ee7b
X-Google-Attributes: gidfe428,public
X-Google-Thread: 10b2b7,a829c3e5e099ee7b
X-Google-Attributes: gid10b2b7,public
X-Google-Thread: f6611,a829c3e5e099ee7b
X-Google-Attributes: gidf6611,public
X-Google-Thread: 11355a,a829c3e5e099ee7b
X-Google-Attributes: gid11355a,public
X-Google-Thread: ff0ac,a829c3e5e099ee7b
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 104de1,a829c3e5e099ee7b
X-Google-Attributes: gid104de1,public
X-Google-Thread: fc5c9,a829c3e5e099ee7b
X-Google-Attributes: gidfc5c9,public
X-Google-Thread: fa0ae,a829c3e5e099ee7b
X-Google-Attributes: gidfa0ae,public
From: Jesse <jcs.random@asu.edu>
Subject: Re: FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL
Date: 1998/07/31
Message-ID: <35C2111B.7B1CF45F@asu.edu>
X-Deja-AN: 376757405
Content-Transfer-Encoding: 7bit
References: <35b34732.0@news.munich.netsurf.de> <35BD7ADA.CC1347A5@ozemail.com.au>
To: Ken Hince Jr <hince@ozemail.com.au>
Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353"
Organization: chaos, inc
Mime-Version: 1.0
Reply-To: jcs.random@asu.edu
Newsgroups: comp.lang.perl.misc,bit.databases.mssql-l,bit.listserv.sqlinfo,comp.databases.ms-sqlserver,comp.databases,comp.databases.filemaker,comp.databases.ms-access,comp.databases.oracle.marketplace