+ Reply to Thread
Results 1 to 2 of 2

Cannot Save Export Specification

  1. #1
    Valued Forum Contributor ffffloyd's Avatar
    Join Date
    05-20-2008
    Location
    Sydney, NSW, Australia
    MS-Off Ver
    2010
    Posts
    207

    Cannot Save Export Specification

    I am new to Access and am trying to export a database in tab separated form so that I can import it to DB2 on another machine.

    The first problem I encountered is that it only seems to be able to export one table at a time, not the entire database (unless there is a hidden option that I don't know about). I am looking at the External Data | Export | Text File selection. The Text File option becomes unavailable if I highlight more than one table.

    All that aside, the thing that renders me unable to proceed is this. After paging through the wizard to set up the export format, I hit Finish to do the job. It responds with the message: "An error occurred trying to save import/export specification NAME". Its default name contains spaces but I have tried replacing spaces with underscores, all the way down to just providing three letters (even one letter) but it always results in an error. Furthermore, it does not appear to perform the export unless it is able to save that specification.

    I am working on a standalone laptop using Windows 7 Professional and Access 2007 (SP2 if that is relevant).
    Last edited by ffffloyd; 04-16-2012 at 11:47 PM.
    _______________
    Floyd Emerson
    Data Warehousing Consultant
    Sydney, NSW, Australia

  2. #2
    Valued Forum Contributor ffffloyd's Avatar
    Join Date
    05-20-2008
    Location
    Sydney, NSW, Australia
    MS-Off Ver
    2010
    Posts
    207

    Re: Cannot Save Export Specification

    Never mind. I exported the tables to Excel and have created them in tab separated form from there.

    Now, how can I add to my own reputation for solving my own problem?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts