By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

Import Excel text to Access memo, preserving carriage returns

P: 2
I have searched the web forums, and can't seem to find an answer to this particular problem I have.

In an excel sheet, cells in one column have formatted text in the "wrapped" cells. For many of the cells it is far more than 256 char.

After import to Access, the carriage return (CR) and Line Feed (LF) is shown with a square symbol in the text, and the text is just "dumped" into the field without CR or LF. Have also tried to indentify the "square symbol", which obvoiusly is related to "chr(13) & chr(10)". Sometimes I also see CR as this character: | . Linking the excel or importing have no effect what so ever, and running an append query is not helping.


I have tried many sorts of ways to keep the formatting, but have been forced to manually copy each cell by select and paste into access. The paste is then done in a form with a memo field.

Is there a friendly soul out there that can help me to figure out how to maintain the "wrapped text" formatting from Excel, after import to Access?

(by formatting I only refer to CR and empty line changes. Never mind the fonts, bullits etc)

Thankyou in advance

JollyRoger

(Using WinXP/Office 2003/ Access 2003)
Attached Images
File Type: jpg Access-table.jpg (25.0 KB, 991 views)
File Type: jpg Excel-table.jpg (23.9 KB, 818 views)
Sep 18 '08 #1
Share this Question
Share on Google+
1 Reply


P: 2
Hi again! I found a way, but I am not sure if it is the best. Microsoft have posted an Access 2000 solution here: http://support.microsoft.com/kb/210372

Atleast I can get on with it now...(gosh..lokked for an answer for years..and here it was..)

JollyRoger
Sep 18 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.