If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Getting data into memo fields
I have never used memo fields in Access. I have data now in an APL
component file that I'd like to import into memo fields. While some descriptions are a single line, some are a variable number of lines. I do not want these lines to wrap. APL, being a raw language, will let me format this data in any way needed. It may be easier to get it into Excel first, and then Access. What line ending delimiter should I use for the multi-line fields? Any tips on how to best do this? Don donwiss at panix.com. |
#2
|
|||
|
|||
Hi Don,
A pretty reliable way is to export to a CSV file and have Access import that. For multi-line text fields, you need to ensu 1) the entire field is delimited (qualified) by quote marks 2) any quote marks within the data are doubled "" Both the file's record separators and the linebreaks within the memo fields must be CRLF pairs (hex 0d 0a). E.g. 1,"Short Text","Steven asked, ""What time is it?"" On a new line, Paula replied, ""I don't know.""" 2,"Next record" On Mon, 10 Jan 2005 20:15:52 -0500, Don Wiss wrote: I have never used memo fields in Access. I have data now in an APL component file that I'd like to import into memo fields. While some descriptions are a single line, some are a variable number of lines. I do not want these lines to wrap. APL, being a raw language, will let me format this data in any way needed. It may be easier to get it into Excel first, and then Access. What line ending delimiter should I use for the multi-line fields? Any tips on how to best do this? Don donwiss at panix.com. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
#3
|
|||
|
|||
On Tue, 11 Jan 2005, John Nurick wrote:
A pretty reliable way is to export to a CSV file and have Access import that. For multi-line text fields, you need to ensu Thanks. I got a chance to work on this today. My biggest problem was after I was done I looked at the table and I only saw the first line of the memo field data! The data did have a few quote marks in the data that was to go into the memo fields. As I already had a function that replaced characters, it was easier to replace them with single quotes. I found that an easy way to check that the quotes were alright was to open in Excel (the default for a filetype of csv). A quick scroll down showed if there were any problems. Don donwiss at panix.com. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
BUG: Using GROUP BY in query expression on MEMO fields it truncates data in MEMO fields to first 255 characters | [SolarAngel] | Running & Setting Up Queries | 5 | December 7th, 2004 06:29 PM |
BUG: Using GROUP BY in query expression on MEMO fields it truncates data in MEMO fields to first 255 characters | [SolarAngel] | Setting Up & Running Reports | 5 | December 7th, 2004 06:29 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
VBA Code problem error 9 | Speedy | General Discussion | 19 | October 15th, 2004 09:05 PM |
Moving data from popup to subform | John Nurick | Database Design | 0 | May 6th, 2004 06:19 AM |