Re: Linking to a .prn file

thanks John! I was able to modify the registry, and allow MS Access to link
to .prn files.

I first tried the VBA solution, but I only have read-access to the network
folder, so modifying the extension name wasn't possible unless I
programatically copied over the file to my local drive, and then made the
file extension switch locally.

I appreciate the help.

Brian


"John Nurick" wrote:

> Hi,
>
> If it's a standard comma-separated file and you're using a recent
> version of Access, then the problem is being caused by the .prn
> extension. Either change the extension (preferably by getting Telephony
> to modify their script) or see http://support.microsoft.com/?id=304206
> to change the extensions that Access will accept.
>
>
>
> On Thu, 26 May 2005 17:15:01 -0700, "br" <br@xxxxxxxxxxxxxxxxxxxxxxxxx>
> wrote:
>
> >Hello:
> >
> >I am working with a very old Telephony switch and am charged with extracting
> >data from the switch and into a database. A staff member in Telephony has
> >created a script that pulls data off the phone switch every day into a .prn
> >file. the file is a comma-delimited file with no headers.
> >
> >My question is, how do I link to (or import from) a .prn file? I can only
> >find ways to connect to a multitude of text-type files.
> >
> >Thanks!
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.
>
.

Relevant Pages

  • Re: perl -pi -e for specific line number
    ... pk schrieb: ... Yes but my problem ist that this command does not modify the input ... thereby making a backup copy). ... if the extension doesn't contain a `*', ...
    (comp.unix.shell)
  • Re: perl -pi -e for specific line number
    ... Yes but my problem ist that this command does not modify the input ... When the end of the file is reached, the temporary file is renamed ... thereby making a backup copy). ... if the extension doesn't contain a `*', ...
    (comp.unix.shell)
  • Re: English Prime ( E-Prime [To Exist or Not to Exist])
    ... How would the varying temporal extension denotation be used to interpret the ... The electron appears as a wave when measured with instrument-l. ... John appears lethargic and unhappy in the office. ... The car involved in the hit-and-run accident was a blue Ford. ...
    (sci.logic)
  • Re: Memory Manager DLL Validation
    ... > Hi John, ... >> NOT modify any data beyond the last used character. ... we should never read or write beyond the null terminator ... but I believe even that was an oversight. ...
    (borland.public.delphi.language.basm)
  • Re: Linking to a .prn file
    ... If it's a standard comma-separated file and you're using a recent ... Either change the extension (preferably by getting Telephony ... >data from the switch and into a database. ... >created a script that pulls data off the phone switch every day into a .prn ...
    (microsoft.public.access.externaldata)
Quantcast