Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Remove Carriage Return from imported Excel Spreadsheets

You import a spreadsheet and you noticed in some of your fields you have a little box with a question mark in it (see image below). This is a Carriage Return (Alt+Enter in Excel).

To remove create an UPDATE query and run against the offending field…

UPDATE YourTable SET FieldContainingCarriageReturn = […]

5,461 total views, 1 views today

UPDATE Query Samples

Simple UPDATE query…

UPDATE YourTable SET YourTable.YourField1 = "Your Value";

Update a field in your table with values from another field in your table…

UPDATE YourTable SET YourTable.YourField1 = [YourField2];

Update a field based on a field on your form… Note: The form must be open to perform this action!

TEXT

UPDATE YourTable SET YourTable.YourField1 […]

247 total views, 1 views today