Print Page | Close Window

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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net