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@roadsysinc.com
> 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
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar