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