Re: Bulk Insert from SQL server to Access
From: Val Mazur (group51a_at_hotmail.com)
Date: 04/27/04
- Next message: Val Mazur: "Re: SQL Server Scema"
- Previous message: Greg Linwood: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- In reply to: aparna: "Bulk Insert from SQL server to Access"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 26 Apr 2004 23:51:03 -0400
Hi,
Best and fastest way to do this is to use SQL DTS. You could use it from SQL
Server or use DTS COM model from the application
-- Val Mazur Microsoft MVP "aparna" <adesai@spryance.com> wrote in message news:eBZCl42KEHA.1192@TK2MSFTNGP11.phx.gbl... > Dear all, > In my program I am fetching a record form SQL server and Inserting into > Access > I am doing this using do while Loop. > can I insert all the records in Access at a time? > pls reply urgently > >
- Next message: Val Mazur: "Re: SQL Server Scema"
- Previous message: Greg Linwood: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- In reply to: aparna: "Bulk Insert from SQL server to Access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
