Access Export Query newline characters appear in Excel

I have an Export Query set up in Access 2007 (linked to SQL Server 2005 tables), which exports to an Excel 2007 spreadsheet. On my PC, it displays correctly, but on another user's it shows the newline characters (or 'carriage returns', in 'memo' fields) as small boxes, which also print. Whilst I could write some VB to remove them from the spreadsheet, it occurs to me that there must be some setting that is different between the two PCs, which are both running the same version of Office 2007. Mine is running Vista Business, and the other XP, but I think the problem is also apparent on another Vista PC.

I have found numerous routines for replacing Chr(10) and Chr(13), but nothing about this apparent discrepancy between similar setups.

Any ideas?

Steve

I would be staggered if the CrLf character is not there in both cases. I would suspect either a code page issue during the import that is not showing it or simply the font being used in the different versions where one doesn't have a representation of that character

Nick,

I checked the other PCs this morning, and found that in fact the other Vista PC does NOT have this problem - it's just the XP one, which does suggest a code page issue. The font used is the same (Arial).

I have also saved the file on the XP machine and can confirm that the newline characters do NOT appear when opening the same file on a Vista PC.

The question is, is there a simple way of adjusting the XP code page to fix this?

Thanks for your response.

Steve

I think you should have the ability to set that when you set up the connection to the database. Equally you should be able to look at it restrospectively by looking at the ODBC connection in control panel or OLEDB connection file if using that technology.