Importing Access data to SQl Server 2000
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15150
Printed Date: 29 March 2026 at 7:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Importing Access data to SQl Server 2000
Posted By: bc_bytes
Subject: Importing Access data to SQl Server 2000
Date Posted: 19 May 2005 at 9:23am
|
I have an Access database table with a number of text (memo fields) that contain "CRLF, hyphens, commas, apostophes, quotes, and formatting tags" that I'm importing into a sql server database table.
The issue is the sql server table doesn't import these, so where what should have been displayed a paragraph, with sentences and formatting is now a big blob of text.
Anyone have an idea what I should be doing in the import from Access to SQL?
|
Replies:
Posted By: dpyers
Date Posted: 19 May 2005 at 10:07am
|
sql data fields shouldn't contain single or double quotes - it's part of the sql syntax and can alter sql statements.
Check out the field validation routine used in the forum code. It replaces "bad" characters with their ascii counterparts. ------------- 
Lead me not into temptation... I know the short cut, follow me. |