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,
Question
Creating MS Access files
+1Hi,
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+22- 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.