okay i had a problem with importing a .txt file into excel as it was 150,000+ lines (this .txt file is exported from a in-house software that i'm using to export to excel and no there are no other ways to export) (oh also the file opens automatically in excel but cant load completely, the .txt...
okay i had a problem with importing a .txt file into excel as it was 150,000+ lines. i tried to import to Access but i get errors. i fixed most of them by bringing in most of the dates as "text" instead of Date/time as they would error that way. I am still having trouble with a date and time...
Ok heres my dilemma, I am running reports from a inhouse software that exports ONLY to excel. this leads to many problems as the reports are VERY large, 100,000 rows or more, they take about 20 mins to run and then they give the error of "file not loaded completely" they are exported as a .txt...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.