1 Reply Latest reply on Oct 7, 2011 2:15 PM by philmodjunk

    what to anticipate transferring data from microsoft access

    ismeta

      Title

      what to anticipate transferring data from microsoft access

      Post

      Hello Knowledgable People,

      I work for a small non-profit that would like to upgrade from a PC using Windows XP to a new Mac laptop.  The challenge we are having is anticipating how much chaos will ensue in transferring the data from Microsoft Access 2000 to Filemaker.

      We are a member-based organization and use Access to track individual contact information; membership join date, renewal and expiration; and some personal information:  ex) professional training, area of expertise, etc.

      I am tracking expiration dates, creating mail merges, labels, etc.  Basic functions at this time, and could expand to other functions in the future.

      It seems the database software is the only information that will not transfer directly to the Mac - all other files aren't a problem.

      Does anyone have experience with this and can offer some advice/tips/warnings or other options?  Loading Windows onto a Mac just to use it for Access seems excessive.  

      my many thanks

        • 1. Re: what to anticipate transferring data from microsoft access
          philmodjunk

          If you do this, you will be able to import the data, each table in your Access database can be imported into the same FileMaker file to create a matching table with data in the FileMaker file, but you won't have imported any of the forms, reports, visual basic code etc. This gives you just the raw data and then you'd need to reconstruct any relationships and layouts needed to get it to work. This is not especially difficult, but it will take time and requires at least a basic understanding of how FileMaker Pro works. It doesn't do SQL so things that you'd manage with a SQL expression in Access require a very different approach in FileMaker.

          If you decide this is what you want to do, you can use the "analzye with Excel" tool in Access to generate an excel file with the requisite field and date for each table in your Access database. You can then drag and drop one of these excel files on the FileMaker application to create a new fileMaker file and import all the data from the excel file into it. Then you can open this new file and use Import records to import the data from the other files into separate tables in the FileMaker file.

          Then the fun begins as you link your tables in relationships and create layouts, scripts, value lists, etc to make your FileMaker File work for you.