Linking to a .prn file

[br]

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]

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.

 

[br]

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