How do I create an empty MS Access table in FME workbench without any records? If I use the creator, it will create one empty record but I need just an empty table.
Thanks,
How do I create an empty MS Access table in FME workbench without any records? If I use the creator, it will create one empty record but I need just an empty table.
Thanks,
Hi,
The Microsoft Access writer will write at least one record when creating a new table anyway, but you can delete the record with setting a SQL "DELETE" statement to the "SQL Statement to Execute After Translation" parameter of the writer. e.g.
delete from my_table;
You can find the parameter under the writer displayed in the Navigator window.
Alternatively, if the database (*.mdb or *.accdb file) exists, you can execute SQL "CREATE TABLE" statements to create empty tables using the SQLCreator or SQLExecutor.
Takashi
If you want a quick (and dirty) way you can use a Creator to create a dummy object and a SQLExecutor to create the table using a SQL statement.