cpn file

[Pam Coleman]

We are exporting an access table which runs everyday from a make table query.
Is there a way to export the file with the extension .cpn? It is a list
that looks like a txt file, but the system that will open it looks for a .cpn
extension. Thanks,

 

[Steve Schapel]

Pam,

No. You would have to export it to a .txt or .csv file. You could
rename the file after it is exported, but as far as I know this is not
possible with a macro, you would need to use a VBA procedure for this.