Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-11-2019, 02:25 PM   #1
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,285
Thanks: 115
Thanked 3,088 Times in 2,806 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Import/Export Data Tasks

A current thread by smig https://www.access-programmers.co.uk...d.php?t=307860 reminded me of the differences in the old and new methods of importing/exporting files.

In the past, import/export specifications were stored to two system files MSysIMEXSpecs and MSysIMEXColumns. However the newer method involves Data Tasks which are generally both easier to use and more powerful.
However I'm not aware of any method of editing an existing data task NOR can I discover where the task is stored.
System table? If so, which?
Registry? If so, where?
Access file property? If so which?

Can anyone assist with answers

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-11-2019, 02:32 PM   #2
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,525
Thanks: 441
Thanked 841 Times in 812 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Import/Export Data Tasks

Would that be for 2010 onwards Colin?

There are some functions here that are meant to amend and they also mention your Specs and Columns files for earlier versions.
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Old 11-11-2019, 02:55 PM   #3
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,285
Thanks: 115
Thanked 3,088 Times in 2,806 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Import/Export Data Tasks

Hi Paul
Yes. The changes to import/export data tasks were introduced in A2010

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-11-2019, 03:37 PM   #4
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,523
Thanks: 58
Thanked 1,424 Times in 1,405 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Import/Export Data Tasks

Hi Colin. Maybe I am remembering this incorrectly, but I think those specs are stored as XML in a collection somewhere.

Sent from phone...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-11-2019, 03:47 PM   #5
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,285
Thanks: 115
Thanked 3,088 Times in 2,806 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Import/Export Data Tasks

That was my first thought as well but they definitely aren't stored in the MSysAccessXML system table
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-11-2019, 04:17 PM   #6
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,523
Thanks: 58
Thanked 1,424 Times in 1,405 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Import/Export Data Tasks

I'll try to dig into it when I get home in case I find anything at all.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-11-2019, 04:20 PM   #7
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,285
Thanks: 115
Thanked 3,088 Times in 2,806 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Import/Export Data Tasks

TIA. My online searches were unsuccessful. I may try searching using WIA.
It has to be within the application rather than the registry as the data tasks still work if you move the app to another workstation

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-11-2019, 04:24 PM   #8
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,280
Thanks: 96
Thanked 2,031 Times in 1,978 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Import/Export Data Tasks

Colin,

I checked a database (O365 version 16) and my import specs are as below
Attached Images
File Type: jpg ImportSpecLocation.jpg (105.5 KB, 16 views)
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is online now   Reply With Quote
Old 11-11-2019, 05:04 PM   #9
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,304
Thanks: 15
Thanked 1,597 Times in 1,517 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Import/Export Data Tasks

Quote:
However the newer method involves Data Tasks which are generally both easier to use and more powerful.
I'm going to have to disagree with that assessment. They are one of those "improvements" are are designed to shelter people from details. If you can't get to the details, you can't change anything including the source file name or location. You also can't use the same spec for multiple imports as you can with the earlier method. I have a process that both imports and exports the same file type and I use the same spec whether I am importing or exporting. The new, "improved" method can't do that. At my last client, I had to convert from the new to the old at least a dozen times for different people. They frequently made little databases that they shared among themselves. However, what would run on one person's PC wouldn't run on another's since the file paths were never the same. So I had to change all the import/export actions to use TransferText or TransferSpreadsheet so the source/target could be controlled by the user.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is online now   Reply With Quote
Old 11-11-2019, 05:18 PM   #10
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,523
Thanks: 58
Thanked 1,424 Times in 1,405 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Import/Export Data Tasks

Quote:
Originally Posted by isladogs View Post
TIA. My online searches were unsuccessful. I may try searching using WIA.
It has to be within the application rather than the registry as the data tasks still work if you move the app to another workstation
Hi Colin. I think I found what I was thinking of. Check out:


CurrentProject.ImportExportSpecifications


Hope that's it...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-11-2019, 05:19 PM   #11
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,523
Thanks: 58
Thanked 1,424 Times in 1,405 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Import/Export Data Tasks

And the XML I was talking about in the other thread is in here:


CurrentProejct.ImportExportSpecifications(0).XML
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by theDBguy; 11-11-2019 at 05:45 PM.
theDBguy is online now   Reply With Quote
Old 11-11-2019, 05:43 PM   #12
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,280
Thanks: 96
Thanked 2,031 Times in 1,978 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Import/Export Data Tasks

Thanks dbGuy I found 3 other (different) import specs
with
?CurrentProject.ImportExportSpecifications.Count
3

?CurrentProject.ImportExportSpecifications(0).XML
Code:
<?xml version="1.0" encoding="utf-8" ?>
<ImportExportSpecification Path = "C:\Users\Jack\Documents\AllEventsSep24A.txt" xmlns="urn:www.microsoft.com/office/access/imexspec">
      <ImportText TextFormat="Delimited" FirstRowHasNames="true" FieldDelimiter="{Tab}" TextDelimiter="" CodePage="65001" Destination="AllEventsSep24A" >
               <DateFormat DateOrder="DMY" DateDelimiter="-" TimeDelimiter=":" FourYearDates="true" DatesLeadingZeros="false" />
           <NumberFormat DecimalSymbol="." />
             <Columns PrimaryKey="{Auto}">
                        <Column Name="Col1" FieldName="Level" Indexed="NO" SkipColumn="false" DataType="Text" Width="12" />
                        <Column Name="Col2" FieldName="Date and Time" Indexed="NO" SkipColumn="false" DataType="Text" Width="22" />
                        <Column Name="Col3" FieldName="Source" Indexed="NO" SkipColumn="false" DataType="Text" Width="43" />
                        <Column Name="Col4" FieldName="Event ID" Indexed="YESDUPLICATES" SkipColumn="false" DataType="Long" Width="9" />
                        <Column Name="Col5" FieldName="Task Category" Indexed="NO" SkipColumn="false" DataType="Text" Width="14" />
                        <Column Name="Col6" FieldName="Field6" Indexed="NO" SkipColumn="false" DataType="Text" Width="130" />
             </Columns>
   </ImportText>
</ImportExportSpecification>
and 2 others, but not the one in MsysIMEXSpecs??
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is online now   Reply With Quote
Old 11-11-2019, 05:45 PM   #13
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,523
Thanks: 58
Thanked 1,424 Times in 1,405 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Import/Export Data Tasks

Right. I think this is the new place where it's stored. Either that or the two places store different things now.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-11-2019, 11:29 PM   #14
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,285
Thanks: 115
Thanked 3,088 Times in 2,806 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Import/Export Data Tasks

Thanks both. Will look at that later today.
MSysIMEXSpecs was used prior to 2010. It still exists but only for backwards compatibility.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-12-2019, 10:13 AM   #15
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,285
Thanks: 115
Thanked 3,088 Times in 2,806 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Import/Export Data Tasks

For info I've just uploaded a new thread to the repository with code to view & edit the XML in the import/export data tasks:
https://www.access-programmers.co.uk...86#post1650586

Many thanks to jdraw & the DBGuy for providing the info needed to get me started and to smig for suggested a procedure that I adapted for my own use

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
The Following 2 Users Say Thank You to isladogs For This Useful Post:
jdraw (11-12-2019), theDBguy (11-12-2019)
Reply

Tags
import export data tasks

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import and export data wgma General 4 02-13-2009 12:29 PM
Import/Link Outlook Tasks into Access airforceruss Modules & VBA 2 02-13-2008 10:02 AM
[SOLVED] Import/Export data only DJN General 3 11-17-2004 07:36 AM
Export / import data le888 Forms 6 06-11-2004 04:51 AM
Can you import Tasks from Outlook into an Access Form? Vaso022578 Modules & VBA 1 09-14-2000 08:54 AM




All times are GMT -8. The time now is 10:51 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