I want to write to an MS Access File - which I have been able to do successfully. However, it requires me to create the blank Access file manually before running the workspace. Is there a way inside FME to create a blank MS Access File?
Thanks,
+21- Contributor
If you mean you are needing to create an MDB with no tables in it manually before you can write table content into the MDB... that's not my experience.
Simply add an MS Access writer to your workspace, add a featuretype to the canvas and connect your data to it. As long as your table has 1 or more attributes defined in it the table will be created inside a new MDB file.
Hope that helps.
Hi,
my experience matches that of Dave's.
I just tested with FME2013sp2 and FME2012sp4, they both created the mdb file just fine.
David
+1ok thanks , I thought I tried it before but it asked me for an existing file, but I'll give it another go.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.