access 2007 - carriage returns, square box characters

V

VaTech2k

I am new to Access 2007. In previous versions of Access, I was able to run
an update query to place carriage returns in place of square box characters
that were showing up after importing Excel spreadsheets into the database
(Article ID 210372). Unfortunately this solution does not appear to work in
Access 2007. Perhaps I am missing something? Has the code for the module
changed or the string in the update query? Any help would be greately
appreciated!
 
A

Allen Browne

A2007 uses the same CrLf for new lines.

Are you sure the code is running? By default, no code runs in A2007 unless
your database is in a trusted location.

To trust your folder, click:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query returns Arabic and/or sanskrit characters 4
carriage return error when importing excel into access 1
adding a Carriage Return or Line Feed character to an update query 3
URGENT! Problem with carriage return & square characters! 2
Restoring line breaks in memo field 2
Display or hide control characters in Excel 2007 1
Replace Excel carriage return boxes in Access 2007 1
Carriage return in text box. 2

Top