Bulk Insert

From: Brandon Campbell (BrandonCampbell_at_discussions.microsoft.com)
Date: 10/26/04


Date: Tue, 26 Oct 2004 09:35:10 -0700

Hello,

I would like to copy the entire recordset of a MS Access table and insert it
into a corresponding table. The first table is located on a different folder.
I have access to this folder. I would like to do a bulk insert of the
recordset into the destination table.

I cannot find any syntax for doing this. Could someone please direct me to
page or give me an example of doing a bulk insert with ADO.

Thank you,

-- 
--------------------------------------------
Database Administrator
bkc5  AT  CDC  dot   GOV


Relevant Pages

  • Re: Need help with MapiTable and EntryID/StoreID
    ... 0x0070001E"" FROM Folder WHERE (""http://schemas.microsoft.com/mapi/ ... Set Recordset = Table.ExecSQL ... OutlookSpy - Outlook, CDO ... If an email is marked with a prefix no records will be returnd. ...
    (microsoft.public.outlook.program_vba)
  • Re: Need help with MapiTable and EntryID/StoreID
    ... end of the while loop, ... OutlookSpy - Outlook, CDO ... Dim Recordset ... I tried this with the contacts folder and with the inbox folder. ...
    (microsoft.public.outlook.program_vba)
  • Re: Export Exchange Public Calendar
    ... folder with ADO, you will need to iterate the folder and work with the ... Furthermore, Outlook doesn't have tables. ... Maybe "schema" is not the right word. ... Recordset with ADO and extract the items. ...
    (microsoft.public.outlook.program_vba)
  • Re: Bulk Insert
    ... "Anushi " wrote: ... >> I have access to this folder. ... >> recordset into the destination table. ... >> page or give me an example of doing a bulk insert with ADO. ...
    (microsoft.public.data.ado)
  • Re: FileSystemObject drive error
    ... I copied the folder from the C: drive to the K: drive so that the ... gone there is no error statement but the recordset is still empty and ... You remembered to uncomment the lines that open the recordset, ...
    (microsoft.public.access.modulesdaovba)