By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,122 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,122 IT Pros & Developers. It's quick & easy.

use ODBC to import filemaker file

P: n/a
Hello, i have a filemaker server 5.5 with some shared files.
I don't understand how use ODBC with these files to import a database
in
Access.
Can anyone help me?
Polpe from Italy

Jul 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Polpe,

If your filemaker server has an ODBC driver then you can create a dsn to
the server in

Control Panel/Administrative Tools/Data Sources (ODBC)

if you go to
Control Panel/Administrative Tools/Data Sources (ODBC)

select the System DSN tab. Then click the Add button. This will bring
up a list of ODBC drivers on your computer. I don't know what the
Filemaker ODBC driver is called, but you might look for any driver that
contains the name Filemaker -- or if there is no driver that contains
that name, then look at the file extensions of the ODBC drivers. The
drivers for Access end with .mdb. The drivers for DB2 databases end
with Dbf.

If you don't see any drivers then try searching the web for Filemaker
ODBC driver

Once you have the odbc driver installed go back to the control
panel/admin..tools/data sources...System Dsn tab, Add, select your
driver, click on finish, then name your data source (any name you want)
select the server from the dropdown - note: if the server name does not
appear in the dropdown, you can type the name in. Then select the
database you want to connect to. Click the Test button to make sure
that you have a good odbc connection. The test will say something like
Successfully connencted to the server or something like that.

Then, in access, go to Link Tables from the File menu, in the dialog box
that comes up, go to the dropdown box at the bottom of the dialog
window. Scroll to the bottom of the dropdown and select ODBC
datasources. When the ODBC datasource dialog comes up, select System
DSN. You will see the Dsn you created in the control panel. Select
that and then select a table you want to connect you.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Jul 19 '06 #2

P: n/a
Thank you, but I tried without achievement.... :-(
The ODBC drives of Filemaker exist but I can't indicate the file to
point...

Bye
Polpe

Rich P wrote:
Hi Polpe,

...

Rich
Jul 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.