Create INSERT SQL statements

[Ivan Debono]

Hi all,

Is there a simple way to create a query that creates Insert sql statements
based on a table and its columns and values?

Thanks,
Ivan

 

[Jeff L]

Yes, in Access it's called an Append Query.

 

[Ivan Debono]

Yes, in Access it's called an Append Query.

I know. I would like to generate the insert statements and save them into a
text file.

Ivan