Actually, 'INSERT INTO' is ANSI standard SQL. Some proprietary
interpretations of SQL support just 'INSERT' e.g. SQL Server (but NOT
Jet).

--

am wrote in message . ..
I didn't realize that 'INSERT INTO' was a Jet SQL statement. I could
not find any reference to it in either of two texts on SQL. I
accidentally found it while searching through more posts on Google.

After getting this to work, the file still bloats.

Paul

---------------------------------------------------------------------------------------------------------------

On Mon, 01 Mar 2004 10:08:58 -0700, am wrote:

onedaywhen,

Thanks for the info. Can you provide an example and/or references to
these two SQL statements? I've been searching Google for a while, but
I can't get a handle on it.

Thanks

Paul

---------------------------------------------------------------------------------------------------

On 1 Mar 2004 02:08:35 -0800, (onedaywhen)
wrote:

Rather than use a recordset, instead use INSERT INTO and UPDATE sql
statements to insert and append rows respectively.