Export SQL Server 2000 data into MSAccess Before delete ms access table data

23 Feb 2010 01:02:51

Hello, I want to Insert sqlserver data into ms-Access. This code is very helpfull to insert data into Ms-Access. INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'C:\Test.mdb'; 'Admin';'', 'Select * FROM Voucher') Select * From VoucherSQL but first my ms-Access table data delete and then new Sql Server data insert. Please Solve My problem Thanks In Advance, Jitendra Patel

Jitendra

Junior Boarder

Posts: 3

From 14-May-2009

You're Points: 112

Re:Export SQL Server 2000 data into MSAccess Before delete ms access table data

23 Feb 2010 01:02:51

HI In this way , there is no more options to keep existing records in database. Just look the MSDN to more details [url]http://msdn.microsoft.com/en-us/library/aa276850%28SQL.80%29.aspx[/url] thank you

RRaveen

Gold Boarder

Posts: 156

From 03-Jun-2009

You're Points: 1106

^ Scroll to Top