Solved

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

Posted on 2006-06-22
4
465 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

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…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

743 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

11 Experts available now in Live!

Get 1:1 Help Now