How to load a .prn file over 65 000 lines of data in Microsoft Access
Posted on 2006-06-22
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!!!