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,
Solved
How do I create an empty table in MS Access?
Best answer by takashi
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
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.
- Best Answer
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
+23- Contributor
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.