Access - Import from Excel with Commas
Posted on 2011-02-21
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.