Access won't import vital Excel column.
Posted on 2015-01-29
I'm using Excel data to update an Access table, but the ID number column won't import. The reference ID is needed to update the right records. Is this a formatting issue?
The records that are being imported originally came from Access and was exported and distributed on Excel with the ID numbers on them. The incoming sheets are the updates for the database, but the ID numbers aren't coming back in. Any ideas? Thanks!