Rabu, 30 Oktober 2013

RE: RE: [MS_AccessPros] Export Spec and file extension

 

Can you export to a local h: drive and then rename it and copy the renamed version over to the share?

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 |

beaerospace.com

Passion to Innovate. Power to Deliver

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of winberry.doyce@roadsysinc.com
Sent: Wednesday, October 30, 2013 6:14 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: [MS_AccessPros] Export Spec and file extension

 




Duane,

 

I thought about doing just that, However if I do, I'm going to have to save it local first then rename and then copy it to the network share. Corporate IT has some kind of new procedure where within seconds after a file has been uploaded to a share, it is swept off to the "cloud". It's not there long enough to rename. I guess I'll search for some code examples for Name and how to move a file from one location to another.

 

Thanks for your help!

 

Doyce 



---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

Doyce,

You may need to use the Name statement to rename the file after it is exported.

From Help:
Name oldpathname As newpathname


Duane Hookom MVP
MS Access

________________________________

> To: MS_Access_Professionals@yahoogroups.com
> From: winberry.doyce@...
> Date: Wed, 30 Oct 2013 05:54:15 -0700
> Subject: [MS_AccessPros] Export Spec and file extension
>
>
>
>
> Hello friends,
>
>
>
> Need some help today. I have a procedure where I export a table to a
> CSV file with an export spec. My corporate IT who gets the file changed
> the procedure on their end and they want the file extension changed to
> RSH instead of CSV. Now the procedure won't run. It gives me an error
> that it can't update because the database is read only. Well I change
> the file extension back to CSV and it runs fine. How can I change my
> export spec to allow a file extension of RSH?
>
>
>
> Doyce
>
>
>






This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar