Switch to the "External Data" tab in Access and locate the "Import & Link" group. Click on the "Excel" option. The "Get External Data – Excel Spreadsheet" dialog box opens.

Reader's ability to export text, and Excel's ability to convert text into table data, let you convert PDF forms into an Excel workbook that Access can import. Open a filled out form in Adobe Reader.

Does anyone know how to import excel data into into an Access table and replace the existing data? For example let's say I have an excel spreadsheet with 1st column labeled Name and second column ...