|
||||||
Access MVP (2010-2015) |
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 = […] Several reasons for this… Could be the Excel spreadsheet has too many columns, could be there is some corruption in the Excel spreadsheet, could be the way Access is translating your columns in Excel, could be there are calculated fields in Excel that Access can’t translate for whatever reason. Review the checklist below and see […] |
Have an Access... ential you want to share? Drop me a line!
Note, all tips are moderated before posting. |
||||
|
Copyright © 2024 Access… entials - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
