Using Filemaker pro 12 to Import Excel Files
Posted on 2012-04-04
What i'm trying to accomplish is this:
Move the data from files into staging tables
then move that data into final tables after doing some scrubbing
Basically i'm trying to mimic an ETL enviornment. Here's the issue, i've used ssis/informatic to accomplish these tasks before, including moving the files to archive paths once the process is complete.
Additionally, the file names will change, so in ssis you can assign variables to the filenames using expressions.
Is there an equivellant tool that works with filemaker pro, on macs ?
Can someone show me a sample script to import an excel file if the file were named /users/excel/file_01012012.xlsx then the next day the file would be file_01022012.xlsx i basically would want to import any .xlsx file in the folder (if that explanation helps) that's the biggest challeng i'm having, if i could just get that part to work, i could research a tool that can do this sort of ETL. Is there a free or open source tool that will do this on a mac ?