Jump to content

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


manuela
 Share

This topic is 7294 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 smile.gif" border="0

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

This topic is 7294 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.