Skip to main content

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.


Reply