Solved

How to load a .prn file over 65 000 lines of data in Microsoft Access

Posted on 2006-06-22
4
473 Views
Last Modified: 2008-03-04
HI,

I need to load in a table a .prn (text file) into microsoft access but I'm unable because the file has more than 65 000 lines.

Under 65 000 lines I would open the .prn file in excel and save it as a .xls file in order to import it in an access table. I can not import directly the .prn in access and have to go through excel first but over 65 000 lines excel will trunk the file.

I cannot lose any data. I have found a way around but it's not really efficient. I open the .prn in wordpad and split the file in 2 (under 65 000 lines each) with a copy-paste ation in another text file and open both in excel and save them in .xls to import them into an access table and then in access I combine both table to get back the original file.

There must be an easier way.....HELP!!! Urgent!!!
0
Comment
Question by:MetDia
  • 2
  • 2
4 Comments
 
LVL 58

Accepted Solution

by:
harfang earned 500 total points
ID: 16961661
Hello MetDia

What is the stucture of your .prn file? You could show the first 10 lines here. Also, try to rename it to *.txt and then use the import assistant in Access. I don't think there is something you can import successfully in Excel that Access could not be made to understand...

(°v°)
0
 

Author Comment

by:MetDia
ID: 16961752
the .prn contains more than 120 column separated by a comma

example: "123","456","789",etc.

I have to open it in excel delimit the file with 'comma' and I'll have 1 column per data and then save it in .xls and then import it in access

can i skip the excel comma delimitation part ? if not how do I do this process with a 65 000 lines file ?

0
 

Author Comment

by:MetDia
ID: 16962035
the rename to .txt and then the import worked, thanks
0
 
LVL 58

Expert Comment

by:harfang
ID: 16965442
I'm glad it did. Success with your project!
(°v°)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now