Linking to more than one table with ODBC???

[shkrebs]

Hi there.

I want to import / link a FileMaker DB to my Access DB using ODBC, to eliminate the need of making an export from Access.
The problem (or task ) is that I need informations from more than one table at the same time.

Is this possible?

What I done so far is:

Since FM is not able to link dynamically like in Access, I will need to setup the link every day - and FM can handle this automatically. I've made some queries which is "collecting" the data from the different tables and put them (the data) into a new table I can use for the ODBC driver.
This means I'll have to run this query every morning to update the data for the FM / ODBC link and this is my problem.

It's a very "manually" process and I would like to make it more automatic.
How can I do that?

Any suggentions will be received with a big smile.

Regards
Søren

 

[79ssecca]

You can link as many tables to access as you want. Click on File/Get external data/linktables In the resulting dialog box go to Files of Type (near the bottom) open the pull down and select the appropiate type (ODBC, TEXT, Whatever) If you choose ODBC you will need to create an ODBC Connection (DSN) now everytime you open Access the table(s) will be linked. From there you can use them just like any table created in Access. Well most of the time you can, sometimes there are little hicups that need special attention.

Good Luck
79ssecca

 

[shkrebs]

Hi SSECCA

I promised a big smile - here it is

I see that my mail is not very clear 'cause I want to use the FM as a frontend and not the other way around
Anyway I found a solution where I'm using Access to "collect" the datas from the different tables and then I'm using a script from FM and an ODBC link to read/import the data into FM ever time the a user is opening the program.

It's not 100% but it will do for now

Once again thanks for your help.

Søren