Preserve Formulas When Importing from Excel
When importing Excel data into an Access table, you may sometimes lose data.
When importing Excel data into an Access table, you may sometimes lose data. When this happens, it is often because you're trying to import formulas instead of static data. If the numbers you see in a cell in your worksheet are the result of a formula, they will be imported to Access as blank cells. The solution is to save the Excel worksheet that contains the data you're importing in a new workbook. Then, select the range you want to import and press Ctrl+C to copy it to the clipboard. Then, choose Edit, Paste Special and select the Values option. Click OK. You can then import this sheet into your Access table, instead of the original sheet which contains formulas.
PCMag reviews products independently