Putting Returns back in notes fields

[MattFitzgerald]

I needed to import from an old table into a new table but the tables were not exactly the same so I first exported to excel and made some alterations before pasting into the new table.

All worked fine except for my 2 notes fields which now have little square boxes where previously there were returns.

Is there any way I can do a find and replace. My problem is I do not know when doing a replace how to put the square box in the find option or a return in the replace with option.

as you can probably tell I am a lot more comfortable in Excel and just picking up access skills so:-

1st off any help to resolve would be appreciated
2ndly If any advice should be offered to avoid this in the future would be much appreciated.

Thanks in advance for any advice offered

[MattFitzgerald]

The probem of putting in Excel first caused more problems than I thought as cells in Excel have a smaller limit than Access Memo fields so in some instances my notes fields were incomplete.

I have however managed to resolve by importing the old table and using a unique reference field between the new and the old tables and used a make table query to replace the Notes fields in the new table with those from the old table.

Simple soloution - don't know why I did not think of it earlier.

[Minion]

The probem of putting in Excel first caused more problems than I thought as cells in Excel have a smaller limit than Access Memo fields so in some instances my notes fields were incomplete.

I have however managed to resolve by importing the old table and using a unique reference field between the new and the old tables and used a make table query to replace the Notes fields in the new table with those from the old table.

Simple soloution - don't know why I did not think of it earlier.

Glad you found your answer Matt. Unfortunately sometimes it's the simplest of answers that give us the most trouble.

- Minion -