Results 1 to 6 of 6
  1. #1
    valbor is offline Novice
    Windows 7 Access 2007
    Join Date
    Oct 2010
    Location
    NY
    Posts
    6

    How to learn parameters of Saved Import (not Import specification)


    Please advise how to learn parameters of Saved Import (not Import specification), such as what table it imports into, creates or appends table, what specification it uses, if any, etc. Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    manually import a file, click Advanced tab, load the spec name,
    all the specs will show.

    The target table is not stored here. The spec only tells how the fields are defined.
    importing is done via query or macro that uses the spec as a param.

  3. #3
    valbor is offline Novice
    Windows 7 Access 2010 64bit
    Join Date
    Oct 2010
    Location
    NY
    Posts
    6
    Thanks ranman256, but that's not import specification I'm interested in.
    My question is about Saved Imports functionality (ribbon External Data, button Saved Imports). Need to find out what particular import specification (out of hundred existing) it is associated with, what table it is working against.

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Oh sorry. I dont use them. I attach the external file and run a query to import.

  5. #5
    valbor is offline Novice
    Windows 7 Access 2010 64bit
    Join Date
    Oct 2010
    Location
    NY
    Posts
    6
    Normally I do not use them either, preferring to either link or import via code with a particular specification, but this is not my db, and in order to support it I need to determine which specifications in use by which Saved Import.

  6. #6
    Glenn_Suggs is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    72
    I need information about this post please. I built a procedure with VBA code that uses the TransferText method to import a .csv file into an Access table. All works great until I created a new database in the production area and tried to import the "Import Specification" that I saved and referred to in my code into the new database. The code can't find the input specification and so it stops with an error that the spec is missing. Is there something I'm missing that I need to know without creating the input spec in the new database?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 01-19-2015, 12:34 PM
  2. Import specification help
    By tplee in forum Import/Export Data
    Replies: 8
    Last Post: 01-11-2012, 03:14 PM
  3. Access 2003: Import Specification
    By compooper in forum Import/Export Data
    Replies: 2
    Last Post: 08-23-2011, 01:58 PM
  4. Modifying an import specification
    By ronzul in forum Import/Export Data
    Replies: 3
    Last Post: 11-12-2009, 05:03 AM
  5. import text specification
    By brunoylupe in forum Import/Export Data
    Replies: 12
    Last Post: 08-09-2009, 04:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums