Linking to a .prn file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

br - 27 May 2005 01:15 GMT

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!

Reply to this Message

John Nurick - 27 May 2005 06:13 GMT

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.

>Hello:
>
[quoted text clipped - 7 lines]
>
>Thanks!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

br - 27 May 2005 17:41 GMT

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

> Hi,
>
[quoted text clipped - 20 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message