Access - Import from Excel with Commas


When importing into Access from Excel - cells in Excel that have delimiters/symbols such as comma or slash, are removed and the cell is then imported as blank in an Access table.

Example, a cell with "216, 217" becomes blank in Access table.

Please offer solutions to maintain the original Excel information.

Thank you
Who is Participating?
Richard DanekeConnect With a Mentor TrainerCommented:
Copy/Paste will work if your data is already properly formatted.  In explanation, if your column data is all of the same type:  text, dates, numbers.   Your example has mixed types.
The Import from Excel will start a wizard to permit data import and greater control over each column.
Richard DanekeTrainerCommented:
The key here is the field type.  You have two places where this can be set.  One is in the Excel import wizard, the other is in the Access table definitions.
Use the wizard to ensure that the field (column) type is General or Text.    Use Access table definition to ensure it is set to text.
Once imported, you can use queries or SQL to clean this up.
Or, before importing, you can use Excel Macros to clean this up.
tahirihAuthor Commented:
I generally just use the copy/paste from Excel to Access. The Excel columns were formatted as "General" - but the data did not transfer properly.

Does copy/paste work?

tahirihAuthor Commented:
When I copy/paste one row from Excel to Access - the format remains. However, when I copy/paste the entire table - I am not able to keep the commas, etc.

Please advise, thanks.
tahirihAuthor Commented:
No, it is not working, even with the columns formatted. Let me keep trying. Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.