You may have problems if there are any Field types in FM P that are not implemented in Base. You can also copy these Tables into a new Base database so that you can then use it stand alone from FMP. When you have this connection you will see the Tables in FMP.
In the Base create new database Wizard use the 3rd option “Connect to an existing database” selecting the appropriate method. You would need an ODBC/JDBC driver from FileMaker Pro. You cannot access the Forms, Queries or Reports in that database - the front ends are not compatible. You can create a Base database to connect to the Tables contained in a database created in another software package using an ODBC/JDBC connection. The Access database documenter can help you get most of it.You cannot import into Base a database application created in another software package (nor any other cross importing). All these metadata you'll need to transfer "by hand". It cannot import table relationships (or foreign key relationships) or primary key definitions, null/not null constraints, index definitions or check constraints. Check Querying an ODBC data source from FileMaker Pro.įileMaker can import table data from Access (or other databases). Make an ODBC connection to your Access database, and use it from within FileMaker to import your tables. When you install Office, you normally get ODBC controllers installed by default, so, if you have Access installed in your computer, you're very likely to have ODBC controllers as well. Check: Introduction to importing and exporting data (Access) and Bringing data into FileMaker Pro - Overview and troubleshooting.ĭirect import through ODBC: Directly import the tables from FileMaker by means of an ODBC connection**. You can also try Excel as an intermediate export format (with this format, you may have some limitation if you have long texts). The safest format is normally CSV -comma separated values- although it won't work with FileMaker if you have data with line-feeds or carriage-returns inside. Use intermediate "common import/export formats": Export data from all the different tables in Access in a format that FileMaker Pro can immediately import, then import the exported files from FileMaker. You have basically two options (without resorting to any third party tool, besides ODBC):
0 kommentar(er)
