Skip to main content
Hi,

 

 

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,
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
ok thanks , I thought I tried it before but it asked me for an existing file, but I'll give it another go.

Reply