AnsweredAssumed Answered

importing from an microsoft access table

Question asked by jfalberg on May 16, 2013
Latest reply on May 20, 2013 by philmodjunk

Title

importing from an microsoft access table

Post

     I'm trying to migrate from a Microsoft Access table over into Filemaker using the import wizard but there does not seem to be a direct method.  I tried exporting from access to a dbf file only to find my column headers truncated if above a certain length, and I cannot seem to have any success when trying to use excel or even an xml file unless I'm doing something wrong here. 

      

     I tried xml as follows:

     From Access: right-click desired table, Export, XML File, XML, XSD (defaults)

     From Filemaker in desired database: File -> Import Records -> XML Data Source -> Specify XML Data Source, File, Continue

      

     I get the following FileMaker Pro message:  XML/XSL information is not enough to proceed with import/export

     Help!

Outcomes