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
URGENT! Problem with carriage return & square characters! 2
carriage return error when importing excel into access 1
Replace Excel carriage return boxes in Access 2007 1
Display or hide control characters in Excel 2007 1
Carriage Returns in an Access report. 1
Use InStr to find Excel carriage return 4
Restoring line breaks in memo field 1

Top