FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL 
Author Message
 FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL
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 ?

Many thanx in advance !

:-)  Carlos



Fri, 05 Jan 2001 03:00:00 GMT
 FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL

well, fmp4 imports/exports real nice.  easier than access :)

it will export to a flat html file with just a click.
or you can export/import tab or comma deliminated easily.
I found that much easier than the access hassle.  it's almost
like mr. bill doesn't *want* access to import/export (??).

-Jesse

btw, so far I find fmp a little weird, though.  in converstion
I found out that while it is relational, and I can do anything
I can think of, easily, it doesn't conform to the classic
theoretical definition of relational.

it doesn't use tables, queries, the same way.  there is no sql.
but maybe sql is coming?

why is this crossposted all over the world???

Quote:

> 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 ?

> Many thanx in advance !

> :-)  Carlos

> 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 ?

> Many thanx in advance !

> :-)  Carlos



Thu, 11 Jan 2001 03:00:00 GMT
 FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL
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

Quote:

> 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 ?

> Many thanx in advance !

> :-)  Carlos



Sat, 13 Jan 2001 03:00:00 GMT
 FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL
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

Quote:

> 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


> > 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 ?

> > Many thanx in advance !

> > :-)  Carlos



Tue, 16 Jan 2001 03:00:00 GMT
 FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL
FMPRO's Merge format in the Export As is a perfect solution.  the *.MER is a
comma delimited file with the Field Names as a Header record in exported
File.

TG

Quote:

> 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


> > 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


> > > 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 ?

> > > Many thanx in advance !

> > > :-)  Carlos



Mon, 22 Jan 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL

2. FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL

3. FILE MAKER Pro Compatibility with MS ACCESS, MS EXCEL

4. Ingres to File Maker Pro or MS Access

5. CA-MILPITAS-111217--Management-MS Office-MS Word-MS Excel-MS ACCESS-ORACLE-GROUP CONTROLLER

6. CA-MILPITAS-111217--Management-MS Office-MS Word-MS Excel-MS ACCESS-ORACLE-GROUP CONTROLLER

7. File Maker Pro MAC to File Maker Pro Win95

8. CA-Los Gatos-263754--MS Word-MS Excel-FOXPRO-MS ACCESS-Vantive-ORACLE-Property Administrator

9. CA-Los Gatos-263806--MS Word-MS Excel-FOXPRO-MS ACCESS-Vantive-ORACLE-Property Administrator


 
Powered by phpBB® Forum Software