I've got a spreadsheet with the same field headers in Access and Excel.
I go through the import process under the External Data tab.
I get an error when I try to complete - seems to be a well-recognised error.
When I compare the imported records in Access to the records in Excel, there is one record that has not been imported.
I can't see any settings that would prevent this one record from being imported.
Any secrets about this function?
Many thanks - just joined here and looking forward to getting to know you.
I go through the import process under the External Data tab.
I get an error when I try to complete - seems to be a well-recognised error.
When I compare the imported records in Access to the records in Excel, there is one record that has not been imported.
I can't see any settings that would prevent this one record from being imported.
Any secrets about this function?
Many thanks - just joined here and looking forward to getting to know you.