Append method?

ThanhMai

Guest

Posts: n/a

22nd Sep 2003

Thanks Jack,
I am using db.Excute "Insert into..." It worked perfect.
Best Regards,
TM
>-----Original Message-----
>
>Execute the following SQL:
>
>INSERT INTO name
>SELECT *
>FROM employee
>
>
>Hope this helps,
>Jack
>
>
>>-----Original Message-----
>>Hello all,
>>Could any one show me what is the VB code to append 1
>>record set into the other recordset. Like:
>>
>>select 1
>>use table employee
>>select 2
>>use table name
>>append from 1
>>
>>Thank you very much.
>>TM
>>.
>>
>.
>

« type mismatch error | Check to see if DB is locked »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Append query to append lots of record with range input	domibud	Microsoft Access Queries	7	9th May 2008 02:26 AM
append to front when using ColumnHistory method	=?Utf-8?B?bWJheWN1cmE=?=	Microsoft Access Form Coding	3	23rd Nov 2007 03:02 PM
Append Query in VBA - to append VBA variable values to Access tabl	=?Utf-8?B?QWdlbnQgRGFnbmFtaXQ=?=	Microsoft Access VBA Modules	4	1st Nov 2006 04:25 PM
Excel Automation creates a hidden instance of Excel using the Append Method	ScardyBob	Microsoft Access VBA Modules	4	16th Aug 2006 02:16 PM
Append method error	JonWayne	Microsoft Access VBA Modules	0	4th Mar 2005 08:47 AM