Source of Data = Excel spreadsheet, several columns wide, one of which contains text which basically describes a company, with hard returns embedded in the spreadsheet to seperate the various details so to speak.

The challenge is to import data from the excel spreadsheet into the db, somehow retaining the hard returns, so that when we produce a report the company description will show on the report with the hard returns as was in the excel spreadsheet.

For example:  This is how it would show up in the xcel ss. Some of the details go on for several lines. Need to see the same on report output.
- Publisher of childrens books, with an emphasis on nutrition.  New title launching this year.
- Publisher also has advertising support.
- Recently purchased competitor.  From 1969-1988, publishers revenues were 60 million per year, but in
  1990 saw a slip in revenue as computerized childrens books/games grew in popularity. An so on.

Sorry for long wind. This is beyond anything I have ever done
Can Grow is set to yes.  
Any thoughts would be greatly appreciated.

You probably could search for the ControlChars.CrLf property in that string, and replace it with an empty string.

strText = strText.Replace(ControlChars.CrLf, "")

The ControlChars.CrLf is the equivalent for the vbCrlf in ASP/VB.

Brian

Thanks Brian. That will help with the import, right? Will I then see the CR properly in the report output from the memo fields?

bph

Actually, I screwed up and thought this was an ADO.NET question, but it's not. Anyways, do you have the capabilities to use VBA? You could do it that way. It's been a while. Basically, in the VB module, you search through the records, and replace vbCrLf with an empty string, such as:

replace(strText, vbCrLf, "")

You may be able to do this with an update statement in SQL, but I'm not sure.

Sorry about that,

Brian

Thanks Brian. I'll continue to hack away at it.

Replaces Excel line feed with Access return.


scid=http://support.microsoft.com:80/support/kb/articles/Q115/5/76.ASP&NoWebContent=1