Import .PRN file into Access

[Scott]

I have a file saved as .PRN, the file consists of 3
values as follows:

Order_Number,Customer_Name,Customer_Number

I want to import this file into Access 2002 (XP) using
code that would define the "," as a end for the field,
does anyone know how to do that. ?

Thanks,

Scott

 

[finster26]

Import the file to Excel. Then save it as an Excel file.
Then import it into Access. You won't need any code.
Hopefully you have Excel.

If not, try saving the file as .txt or .csv. You can then
import it directly into Access skipping Excel.

Exel has the ability to import.prn files.

 

[Chris Howarth]

I have a file saved as .PRN, the file consists of 3
values as follows:

Order_Number,Customer_Name,Customer_Number

I want to import this file into Access 2002 (XP) using
code that would define the "," as a end for the field,
does anyone know how to do that. ?

Thanks,

Scott

Open your database, view the tables and right-click on the database window.

Choose Import, change the file type to 'Text Files' and open your .prn file.
Further dialogs will open to allow you to choose between Fixed Width and
Delimited. Choose Delimited and specify "," as the delimiter.

Chris

 

[Douglas J. Steele]

Unless you write code to read the file and parse it yourself, you're going
to have problems doing it programmatically, as Access doesn't recognize PRN
as a valid extension for text files.

See the following KB articles for details:
ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/?id=245407
ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize
http://support.microsoft.com/?id=306144

Other than that, you can use the TransferText method.