| I have been beating my head against the wall because I can't figure out what is going on. When I try to import data into a table I am getting "Field "F42" Doesn't Exist in Destination Table" error. I have a "client lists" table, and I am trying to add additional records to it. Below is my export process: I export my Acess table as an xlsx via the ribbon into Access. When I export I select "keep the formatting". In Excel I delete all the existing records, and add the new ones make sure all formatting and primary keys are correct. I select "keep the formatting" in hopes of making sure all headers are correctly formatted and I have a template for the new data. My import process: I verify all formatting is correct and lines up with my Access database. In Access, I select import from the ribbon, select the correct xlsx, select "Append" database along with the correct table. I click through the wizard and at the end I get this error. I am not using any VBA. Just trying to use good ol' Access and Excel. What am I doing wrong! Thanks for any help. |
<tbody>
</tbody>