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

 

[Michel Walsh]

Hi,


An SQL statement can be store as a string... To read it from a saved query?
or to assign it, use the SQL property

? CurrentDb.QueryDefs("Category Sales for 1997").SQL




Hoping it may help,
Vanderghast, Access MVP

 

[Jamie Collins]

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

Sounds like something that can be done with SQL (i.e. set-based
declarative code) but is probably better done with procedural codee.g.

SELECT 'INSERT INTO Calendar (dt) VALUES (#'
& FORMAT$(dt, 'yyyy-mm-dd') & '#);'
INTO [Text;DATABASE=C:\;].[MyScript#txt]
FROM Calendar;

Jamie.

--