Anh_Tran Posted November 18, 2002 Share Posted November 18, 2002 Dear All, IS Filemaker-Access compatible? ...CAn we import/export from Filemaker to Access database and from Access database to Filemaker? I am new to this kind of Access-Filemaker? CAn we open Access database with the same records from Filemaker files ... Thanks Link to comment Share on other sites More sharing options...
Fitch Posted November 18, 2002 Share Posted November 18, 2002 You can't do it directly, you have to first export from one program in a common format such as tab-delimited text. Then you import the text file. Or you can get really fancy and use ODBC or something... good luck. Link to comment Share on other sites More sharing options...
shkrebs Posted November 20, 2002 Share Posted November 20, 2002 Hi there. Well I've been dealing with this problem for a long time now and MAN - how I'm looking forward to an Open DB standard THAT WORKS.... If it's something you just have to do once then use the DBase format to share the tables/databases. It works very well and you get all the tabledefinitions transfered too. If you want something more dynamically then I'll think the ODBC solutions is the best. Here is some of my experiences so far...: FileMaker 2 Access: The ODBC driver from FileMaker is not very flexible and FileMaker needs to be open for Access can read the database. Access 2 FileMaker: Since FileMaker cannot "link" to a table in Access you have to make an import instead - still using the ODBC driver. This means you have to make an "update-script" in FileMaker where you once again is importing the data from Access, but is not difficult. In general I'll say that those two DB just doesn't like eachother Just like Mac and PC's - so if you have any possibility to choose one or the other then do it If you have any ? with this pls. write me. Best regards S Link to comment Share on other sites More sharing options...
shkrebs Posted November 20, 2002 Share Posted November 20, 2002 I forgot this: http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB13&Number=49862&page=0&view=collapsed&sb=5&o=&fpart=1 S Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7956 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 accountSign in
Already have an account? Sign in here.
Sign In Now