Filemake 4.0 to Outlook

I have a simple contacts database in Filemaker 4.0 (no relationships) I have about 50 fields. Of these 50 fields, there are about 20 that I would like to import into Outlook 2000 Contact manager (the goal is to synch them with Palm Pilot). How can I do that? 100o point question
alexanderyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

VinceACommented:
Have you tried creating a comma separated data file from the FileMaker file? You could then use the File menu > Import & Export command in Outlook to import the data directly into Outlook contacts.
0
snoop_doggy_doggCommented:
If you have an ODBC driver for Filemaker 4.0, then you should probably create an Access database, then create linked tables to the Contacts table in the Microsoft Outlook datasource and the contact table(s) in your Filemaker database.  Then just run a simple query that will map all the fields from on table to the next.

Please let me know if you need more detail.

Woof!
http://www.woofwoofwoof.com
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
alexanderyAuthor Commented:
Could you be more specific please? I have no relationships in FM 4.0 - this should probably make it easier. Can Outlook be linked to FM? That is if I enter data thru FM, can the changes be reflected in Outlook Contacts manager?
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

VinceACommented:
You can't link FM & Outlook. Can FM export its contacts to standard format?
0
snoop_doggy_doggCommented:
I would assume that when you install Filemaker, it also installs an ODBC driver along with it.  If this is the case, from the control panel, create a new ODBC datasource using the Filemaker driver and point it at your contact database.  Once this is done, you can create a new Microsoft Access database and from within this new database, create two linked tables.  The tables you want to create (File menu -> Get External Data -> Linked Tables) should link to two datasources.

After you go through the above menu selections, you will be presented with an "open" dialog box.  From the file type combo box, select ODBC datasource and then choose the Filemaker datasource you created in the first step above.  Then, link the second table with a file type of Outlook() and choosing the Contact folder when presented with a list of your Outlook folders.

Once this is done, write a new query in the Microsoft Access database which will read the records in the Filemaker table and insert rows into the Outlook Contact table with the appropriate column mapping.

Woof!
http://www.woofwoofwoof.com
0
snoop_doggy_doggCommented:
BTW:  You can re-sync the databases at any time by putting a shortcut to that query right on your desktop.  

Woof!
http://www.woofwoofwoof.com
0
alexanderyAuthor Commented:
I cannot find the ODBC driver for FM 4.0. I looked in the install its not there. I looked under ODBC Data Sources in the Control Panel its not there. Does FM 4.0 have an ODBC driver?
0
alexanderyAuthor Commented:
I am using FM 4.03.
0
snoop_doggy_doggCommented:
Filemaker 4 does not include an ODBC driver, however, you can get one from a third party.  If you upgrade to version 5, it does ship with the driver required for this technique.

Woof!
http://www.woofwoofwoof.com
0
alexanderyAuthor Commented:
When I try to link tables it does not give me an option to link with a file type of Outlook - its not under one of the menu selections in the drop-down Files of Type drop-down box.
0
snoop_doggy_doggCommented:
If you don't have that filetype when linking tables, then you must be using a version of Outlook older than 2000.  Microsoft has available on their website add-ins for ealier versions of Outlook that give you this function.

Woof!
http://www.woofwoofwoof.com
0
VinceACommented:
Are you looking for a constant link or a one time transfer?
0
alexanderyAuthor Commented:
OK. Forget the FM. We want to put everything in Access. How? Then we want any information modified in Outlook Contact Manager to be reflected in Access 97 (or 2000 if not possible in 97) and vice versa. How?
0
alexanderyAuthor Commented:
I am looking for a dynamic link between Outlook Contact manager and Access. P.S. Also what is the easiest way to import everything into Access from FM? txt, csv, tab files? Which one? (Added another 350 points to this)
0
alexanderyAuthor Commented:
Adjusted points to 1350
0
VinceACommented:
CSV imports usually work pretty well for me into Access tables. For a live link between Access & Outlook 2000 you might want to take a look at the Small Business Contact Manager that's part of some editions of Office (I know it's in Premium but not sure of the others)
0
alexanderyAuthor Commented:
I installed the Outlook Link/Import Wizards. I can link the tables but I cannot edit the data. The datasheet view does not come up. Why??? I can see the names of the fields in the Design view.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.