Tilted Forum Project Discussion Community - View Single Post - Access -> Excel (CSV), linefeed & square boxes

John Henry · 05-06-2004, 09:01 AM

I need to move data from an access database to an excel spreadsheet, but at the moment, all the linefeeds are coming out as little square boxes. I tried using a bit of vb code from the msdn site, that is supposed to solve the reverse problem (ie. excel->Access) and just swapping the find and replace fields, but this did nothing.

The code is written in such a way that if each field wasn't being fed through this function, nothing would come up on the spreadsheet at all, so the only answer I can think of is that I'm not searching with the correct ASCII code. Anyone know what it's likely to be? Or have any ideas how I can find out? Or can you think of a way round it? Anything, really.

Cheers

JH

05-06-2004, 09:01 AM	#1 (permalink)
John Henry Addict Location: Grey Britain	Access -> Excel (CSV), linefeed & square boxes I need to move data from an access database to an excel spreadsheet, but at the moment, all the linefeeds are coming out as little square boxes. I tried using a bit of vb code from the msdn site, that is supposed to solve the reverse problem (ie. excel->Access) and just swapping the find and replace fields, but this did nothing. The code is written in such a way that if each field wasn't being fed through this function, nothing would come up on the spreadsheet at all, so the only answer I can think of is that I'm not searching with the correct ASCII code. Anyone know what it's likely to be? Or have any ideas how I can find out? Or can you think of a way round it? Anything, really. Cheers JH __________________ "No one was behaving from very Buddhist motives. Then, thought Pigsy, he was hardly a Buddha, nor was he a monkey. Presently, he was a pig spirit changed into a little girl pretending to be a little boy to be offered to a water monster. It was all very simple to a pig spirit."