How export from Access into ODBC databases and import it in a FM db

[manuela]

I don't know how to create an ODBC database from Access and import it in a FM db.

I've tried but it's not so easy.

Who can help me ?

Thanks a lot

MC

[LiveOak]

If this is a one time thing and not a periodic hot update, why not export to some ordinary file format (tab text, SYLK, DIF, DBF)?

I'm not aware that ODBC is a file format. I always thought is was a connection method.

-bd

[Anatoli]

quote:

---

Originally posted by LiveOak:

If this is a one time thing and not a periodic hot update, why not export to some ordinary file format (tab text, SYLK, DIF, DBF)?

I'm not aware that ODBC is a file format. I always thought is was a connection method.

-bd

---

And you are very correct

[bbaliner]

manuela,

I think you mean "ODBC data source" and not "database". ODBC is a pipeline between databases.

[manuela]

quote:

---

Originally posted by BikeBoy:

manuela,

I think you mean "ODBC data source" and not "database". ODBC is a pipeline between databases.

---

Yes, you have reason!

Thank you

mc

[kraftyman]

Connecting to an Access Database is very easy.

I'm assuming you are using windows.

1. Open the control panel

2. Select ODB sources , it should not matter for the single user if you select the "user" or "system" data source.

3. click "add"

4. select "microsoft access driver"

5. make a name for the data source so you can find it again

6. select the database you wish to connect to from the file selector.

7. type in the appropriate user/password if that is required

9. voila!

8. use the normal filemaker processes to import/export/move data

[ November 01, 2001: Message edited by: kraftyman ]

[manuela]

quote:

---

Originally posted by kraftyman:

Connecting to an Access Database is very easy.

I'm assuming you are using windows.

1. Open the control panel

2. Select ODB sources , it should not matter for the single user if you select the "user" or "system" data source.

3. click "add"

4. select "microsoft access driver"

5. make a name for the data source so you can find it again

6. select the database you wish to connect to from the file selector.

7. type in the appropriate user/password if that is required

9. voila!

8. use the normal filemaker processes to import/export/move data

[ November 01, 2001: Message edited by: kraftyman ]

---

[manuela]

EVVIVA

It's true. It is very easy. I HAD SUCCEED !

Thak you a lot.

You know, I have imported about 12.000 records of a collecion of the italian Counstitutional Court'maxims-decisions. It will be interesting to manage all this data with File Maker.

Ciao

manuela

quote:

---

Originally posted by kraftyman:

Connecting to an Access Database is very easy.

I'm assuming you are using windows.

1. Open the control panel

2. Select ODB sources , it should not matter for the single user if you select the "user" or "system" data source.

3. click "add"

4. select "microsoft access driver"

5. make a name for the data source so you can find it again

6. select the database you wish to connect to from the file selector.

7. type in the appropriate user/password if that is required

9. voila!

8. use the normal filemaker processes to import/export/move data

[ November 01, 2001: Message edited by: kraftyman ]

---

[Anatoli]

Manuela,

you will get help here

I am personally checking mostly the Web/CDML parts, but others do check this as you can see.

Thank you for e-mailing me.

Anatoli