This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Imported a CSV file and the last 5 columns had blanks so the data in some rows shows up in the wrong column. How can I move the data to the correct columns?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
My apologies - accidently hit the wrong key before completely my last response so to continue from
>>
When you say that
<<
That the columns show up in the wrong columns, is that data in the same row or data crossing rows?
>>
How can I move the data to the correct columns?
<<
Just going by the description, if columns are showing up in the wrong place, means that the CSV file is improperly constructed - more specifically, does have the correct number of field delimiter characters for "empty fields".
When you say that
It might be better to import the CSV into Excel, use Text to columns to clean it up and then import that file into Access.
yes. About 2.6 Million rows - 70 or so columns.
Do you still have access to the CSV file?
How many records was it?