![]() See Exporting as CSV for more information on CSV files. It is highly recommended to use UTF-8, especially when your data contains characters from foreign scripts. You can however change the encoding to UTF-8 when opening the file. What is an XML File Method 1: Open an XML File in Excel Via the File Tab. MDB Viewer can also export CSV files that are supported by Filemaker Pro.įilemaker always uses the international CSV format (comma as field separator, period as decimal mark).īy default, Filemaker expects files to be encoded in MacRoman. This tutorial shows you three methods for opening XML files in Excel. select "New Table" and "First Row contains field names" and saveįor more on exporting Excel files with MDB Viewer, see Converting Access Databases to Microsoft Excel.in Filemaker, choose "Import data" from the File menu and select a work sheet from your Excel file (FileMaker will only accept one work sheet at a time).To add additional tables to your FileMaker Pro database: To include additional tables from your Access DB you have to import each work sheet from your Excel file seperately as a new table into your FileMaker file. ![]() select "First Row contains field names" and saveĪs a result you have now a new FileMaker Pro DB with one table.when Filemaker prompts you, select a work sheet (FileMaker will only accept one work sheet at a time). ![]()
0 Comments
Leave a Reply. |