How can I modify a saved Microsoft Access 2007 or 2010 Import Specification?

by

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

More Related Contents:

  1. How does one decompile and recompile a database application?
  2. How do you use version control with Access development?
  3. Microsoft Access condense multiple lines in a table
  4. Bang Notation and Dot Notation in VBA and MS-Access
  5. How do I make a stored procedure in MS Access?
  6. How can I get table names from an MS Access Database?
  7. Syntax error in insert into statement – what’s the error?
  8. Is there any way to create multiple insert statements in a ms-access query?
  9. Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb
  10. Microsoft Access DBEngine.OpenDatabase() breaks for Network-Paths – Error 3050
  11. Is it possible to create a recursive query in Access?
  12. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  13. What is the equivalent of Select Case in Access SQL?
  14. MS Access LIMIT X, Y
  15. Prevent enabling of shift bypass – Access 2010
  16. Access 2007 – Left Join to a query returns #Error instead of Null
  17. Access query producing results like ROW_NUMBER() in T-SQL
  18. Pivot Query in MS Access
  19. Save password for ODBC connection to MS SQL server from MS Access 2007
  20. How to write Case Sensitive Query for MS Access?
  21. Setting up an MS-Access DB for multi-user access
  22. Access VBA: Find max number in column and add 1
  23. ConcatRelated function in a query
  24. Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
  25. UrlDownloadToFile in Access 2010 – Sub or Function not Defined
  26. Custom row source for combo box in continuous form in Access
  27. VBA – Run Time Error 3271 using DAO object
  28. Working with multiple programmers on MS Access
  29. Trouble with InputBoxes
  30. Get Name of Current VBA Function

Leave a Comment