Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-14-2012, 11:00 AM   #1
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,798
Thanks: 635
Thanked 337 Times in 307 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Post Import / Export Spec Access 2010 Review

For Access 2003 / 2007 see:
http://www.access-programmers.co.uk/...d.php?t=197604

For Access 2012 - Saved Export Saved Imports

Edit? Don't think there is a way.
However, I needed to figure out what a temp contractor had done.
This provided the information to delete and replace with the same steps & some modifications. Basically, run the script, delete the old Saved Import and recreate (with modification) it with the same name.

Below is an example of the code run in the Immediate window (debug) and the results in Access 2012.
Code:
? access.CurrentProject.ImportExportSpecifications.count
 1 
? access.CurrentProject.ImportExportSpecifications(0 ).name
Import-CCS Data
? access.CurrentProject.ImportExportSpecifications(0 ).description
Changed extenstion
? access.CurrentProject.ImportExportSpecifications(0 ).xml
<?xml version="1.0"?>
<ImportExportSpecification Path="X:\Accounting\Materials Accounting\Propane\CCS File for Import into Access\CCS Data.xlsx" xmlns="urn:www.microsoft.com/office/access/imexspec">
    <ImportExcel FirstRowHasNames="true" Destination="TEST" Range="Sheet2$">
        <Columns PrimaryKey="{Auto}">
            <Column Name="Col1" FieldName="GL Posting Date" Indexed="NO" SkipColumn="false" DataType="DateTime"/>
            <Column Name="Col2" FieldName="SOP Number" Indexed="NO" SkipColumn="false" DataType="Text"/>
            <Column Name="Col3" FieldName="Item Description" Indexed="NO" SkipColumn="false" DataType="Text"/>
            <Column Name="Col4" FieldName="QTY" Indexed="NO" SkipColumn="false" DataType="Double"/>
        </Columns>
    </ImportExcel>
</ImportExportSpecification>

__________________
Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved.

Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading."

There are 2 Kinds of Countries on this Planet
1. Those that use the Metric System
2. Those that had a man walk on the moon

Denver, Colorado - The "Mile High City" - non-metric!
Rx_ is offline   Reply With Quote
Reply

Tags
export , import , saved exports , saved imports , steps

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to edit a saved Import/Export spec in 2007 DCrake General 7 09-14-2016 04:01 PM
Export Report From MS Access 2010 to Word 2010 amir_ayub Reports 0 02-28-2012 11:26 AM
Export Access 2010 Report to Excel 2010 Starchildren3317 General 1 02-01-2012 10:14 AM
print an import spec - ACCESS 2003 mehl General 2 11-06-2008 01:18 PM
Export Text wizard will not start.... how do I create export spec? pungentSapling General 1 07-01-2004 12:46 PM




All times are GMT -8. The time now is 12:57 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World