Import Text with prn extentions

[Mike]

i am trying to build a database,but all the files have the .prn extension. Is
there a way I can import these files through Access? There isnt an option to
choose this type of file when I try to import the data. I added prn to the
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text key, but that
didnt work. Any ideas?

 

[John Nurick]

Hi Mike,

1) Adding "prn" to
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\Extensions
doesn't do the job. You have to follow the instructions in
http://support.microsoft.com/?id=304206 and include it in the list of
extensions excluded from DisabledExtensions.

Alternatively, use one of the other techniques in that article.

2) That will get you to the stage where Access will attempt to import
the .prn file. Whether this will succeed depends on what's in the file:
the .prn extension can mean anything from a tab-delimited or fixed-width
text file to a binary file of printer commands.

 

[Mike]

I previsouly added prn to the list of disabled extensions. That did not work.
I also followed the instructions and that didnt help either. This file can be
opened with notepad. Any other ideas?

 

[John Nurick]

Any file can be opened with Notepad, so that doesn't tell us much. Is it
a regular text data file (e.g. CSV, tab-delimited, fixed-width) or is it
something else (e.g. laid out like a printed report, a binary file of
printer commmands...)?