importing from an microsoft access table
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