Problem exporting to XL

[Manticore]

I'm trying to export FMP 5 records to XL. There are 6 cal fields (text) containing return characters. I export the fields in dbf but it also works using sylk and wks formats. The problem is that when I open the file in XL, I lose the return characters. They are replace by a funny character or by a blank space.

Is there a solution around this?

------------------

Luc Therrien, MN, RN

Ressources.sante@ho

me.com

[email protected]

[Kurt Knippel]

quote:

---

Originally posted by Manticore:

I'm trying to export FMP 5 records to XL. There are 6 cal fields (text) containing return characters. I export the fields in dbf but it also works using sylk and wks formats. The problem is that when I open the file in XL, I lose the return characters. They are replace by a funny character or by a blank space.

Is there a solution around this?

---

ALL, let me repeat that ALL, text based files treat the return character as a record delimiter. You would need to export the data and create some kind of custom parsing macro in Excel in order to do this properly.

My question would be why are you exporting the return character to Excel?

I might suggest changing the Return character to some other odd character, exporting the file, importing it into Excel and then replacing the odd character with the return chracter.

You might also look and see if Excel has some options to deal with this.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=