ACCESS FEED: RE: [MS_AccessPros] is there any way to alter a SAVED EXPORT, I just need to change it's destination

Rabu, 19 Oktober 2011

RE: [MS_AccessPros] is there any way to alter a SAVED EXPORT, I just need to change it's destination

Ah, didn't think of that, Crystal. Cool.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
Sent: Thursday, October 20, 2011 12:35 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] is there any way to alter a SAVED EXPORT, I just
need to change it's destination

Hi Terence,

find the information you want to change in the IMEX tables -- you can use Update
and Append queries on them :) be sure you use its primary key and change the
right rows ;)

The tables that store import/export specs are:

MsysIMEXspecs
MsysIMEXcolumns

Warm Regards,
Crystal

*
(: have an awesome day :)
*

________________________________
From: Terence

Is there any way to alter a saved export. I have a dozen or so, and all I need
to do is change the destination path.

Or do I have to re-create them ?
Terence

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links