Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 24th, 2005, 01:27 AM
Authorized User
 
Join Date: Apr 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ranakdinesh
Default Importing Data to MsAccess

I have a database in Sqlserver we require small chunk of data around 300 records on criteria to import them in Access as few application designed use database as Access. i am writing Asp in C# my problem is i am not getting the right thing to do so. if Extract data from SqlServer and insert it inot database then the Field Lika Address which contains sepecial Cahracters like ' Eg Sikh's raise an error while inserting records in Access.
Can any body help me to get out of this problem. either how to Supress these special characters or any other mathod by which i can easily copy data from Sql Server to Ms Access with ease

dinesh Rana
__________________
dinesh Rana
 
Old February 24th, 2005, 08:38 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

You have to search for a ' in your text and replace it with ''. You have to do that in your C# code. Rather, the easiest way to do this is DTS, works really quickly.

Brian
 
Old February 24th, 2005, 10:03 AM
Authorized User
 
Join Date: Apr 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ranakdinesh
Default

Dear Brian
  How i can build Dts Package in C# with select Quries give me some reference
Thanks
Dinesh Rana

dinesh Rana





Similar Threads
Thread Thread Starter Forum Replies Last Post
SSIS: Use filename as data when importing data slesicki SQL Server 2005 0 August 7th, 2006 05:00 PM
how do i get data from MSaccess by vc++ stumpted Visual C++ 1 July 2nd, 2006 06:15 PM
populate Gridview from MSaccess data alaqunaibi ADO.NET 1 June 19th, 2006 01:25 AM
Writing to an msAccess db from txtBox Data sconineuk ADO.NET 0 March 8th, 2006 03:13 PM
Secure MSAccess db ASP Data Page Integration Will Woodward Classic ASP Databases 1 October 26th, 2005 08:32 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.