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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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
+17- 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.
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.