Question posted 2008 · +27 upvotes
Does anyone know how to modify an existing import specification in Microsoft Access 2007 or 2010? In older versions there used to be an Advanced button presented during the import wizard that allowed you to select and edit an existing specification. I no longer see this feature but hope that it still exists and has just been moved somewhere else.
Accepted answer +31 upvotes
I am able to use this feature on my machine using MS Access 2007.
- On the Ribbon, select External Data
- Select the “Text File” option
- This displays the Get External Data Wizard
- Specify the location of the file you wish to import
- Click OK. This displays the “Import Text Wizard”
- On the bottom of this dialog screen is the Advanced button you referenced
- Clicking on this button should display the Import Specification screen and allow you to select and modify an existing import spec.
For what its worth, I’m using Access 2007 SP1
Top ms-access Q&A (6)
- OleDbCommand parameters order and priority +28 (2009)
- Is there an equivalent to the SUBSTRING function in MS Access SQL? +26 (2009)
- What do I need to read Microsoft Access databases using Python? +25 (2009)
- MS Access library for python +24 (2009)
- is there any replacement of Access? +21 (2009)
- MS-Access – you tried to execute a query that does not include the specified aggregate function +17 (2013)
ms-access solutions on this site
— top 2%.