Get "Invalid Pointer Operation" error when trying to execute the import table data wizard
说明
When clicking the execute button on the import table data wizard an "Invalid Pointer Operation" error is received.
原因
Excel spreadsheet has formulas in it.
解决办法
Make sure there are no formulas on the spreadsheet you are trying to import. To convert the formulas to values, do the following.
1) Highlight and copy the cells that you want to import into the table. 2) On another sheet, paste the cells you copied by right clicking and selecting Paste Special. 3) Make sure Values is checked and click OK.