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

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

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

dinesh Rana