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.
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
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…