How do I edit a saved import in Access?

How do I view a saved import specification in Access?

To view the Manage Data Tasks dialog in Access click External Data > Saved Imports or External Data > Saved Exports. You can click either of the tabs on the dialog box to switch between the saved import and saved export specifications.

How do I use a saved import in Access?

On the External Data tab, click Saved Imports or Saved Exports to open the Manage Data Tasks dialog box. In the Manage Data Tasks dialog box, on the Saved Imports or Saved Exports tab, click the specification that you want to run.

How do you modify Access?

Modify an Access app1Click Settings > Customize in Access in the upper right corner of your browser window. ... 2Click Open when prompted by the browser. ... 3On the left side of the screen, click the table caption name in the Table Selector whose view you want to change, and then click the view that needs changing.

Where is the import wizard on Access?

On the Office ribbon, select the External Data tab and click Excel. The "Get External Data - Excel Spreadsheet" wizard appears. In the File name field, browse to the Excel file. Select the "Import the source data into a new table in the current database" option and click OK.