Microsoft 365 and Office | Access | Other | Windows
A family of Microsoft relational database management systems designed for ease of use.
Importing data into a table from Excel, funky results
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 38%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Patrick Snyder
0
Reputation points
See snippet below, I've imported data from excel to access, several rows but some of the results look like the snippet below. The cell that I am importing from is formatted as Text. The field that I am placing the data into is Short Text.
I have several fields where this is happening but it's not all of them, it just seems random. I am trying to see if there is a common word or character or spacing or something but it just seems like it's random.
How do I fix?
Microsoft 365 and Office | Access | Other | Windows
{count} votes
-
Viorel 125.7K Reputation points2025-12-12T14:09:03.0766667+00:00 What is the correct text in this case?
-
Patrick Snyder 0 Reputation points
2025-12-12T14:17:59.2+00:00 You know it's a funny thing.... I just went back to take a screen shot and all of the text boxes that were messed are ok now. How does that happen? All I did from the time that I posted the question until I got your response, was make sure formatting adjustments to the form. I deleted a couple of text boxes that I decided that I didn't need. I didn't even notice that the funky characters disappeared.
-
Patrick Snyder 0 Reputation points
2025-12-12T16:56:17.62+00:00 I spoke too soon, it came back but in different text boxes.
Sign in to comment
Sign in to answer