Elam, Debbie
DElam at jenkens.com
Thu Nov 11 10:25:00 CST 2004
Thanks, I will see if I can use a more generic printer driver to get the file. Debbie -----Original Message----- From: Jim Dettman [mailto:jimdettman at earthlink.net] Sent: Thursday, November 11, 2004 10:08 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Import from .prn File Debbie, <<Does anyone have suggestions about how to import this file into Access?>> Not to be flippant, but don't<g>. The contents of a .prn file are dependant on the printer driver used to create it. If you have no control over that, then the contents and encoding of that file could/will be different from one file to the next. If you do have control over the file creation, use the Generic Text Only driver to produce it. You should be able to use the Access Import Wizard at that point or use VB code to read it in line by line. Jim Dettman -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Elam, Debbie Sent: Thursday, November 11, 2004 10:49 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Import from .prn File I am trying to import some data from a .prn file. When I open the file in notepad it gives me gibberish, so I assume I will need to open it or convert it with specific software. I found a trial version of ABC Amber CSV converter. It claims to be able to convert a .prn to an Excel spreadsheet. The trial version only imports 10 records, and they look just like the gibberish in notepad, just put into columns. I am a little reluctant to spring even for $14.95 given the trial performance, but I have not found anything else to allow me to read this file properly. Does anyone have suggestions about how to import this file into Access? Debbie - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions.