Originally Posted By: escanlan This post was automatically imported from our archived forum.
Trying to import a 25,000 line text file into Excel 2003. Microscrew, in their infinite wisdom, has not yet realized that text files can be larger than 65, 536 lines long. The import stops after that and says “Thank you for using Microscrew Office, if we can destroy your day in the future please allow us” . Actually it stops after one worksheet and tells you to use the Wizard to import the rest instead of just automatically continuing on to successive sheets.
During the import setup there is an option to use a formula for the import. Does anyone have an example formula for this case? Would need to start the import again and exclude any line items already found on previous worksheets.
Originally Posted By: jpope This post was automatically imported from our archived forum.
What have you used in the file as “separators?” Dependant upon the format, you’ll need to tell Excel what to do with it (comma delimited, tab delimited or fixed fields). Excel can import huge (long) records but only allows import of 65.5K total records. Access, on the other hand, will allow over 500K imported.
If you only have 25K records, Excel will handle it. Send it to me and I'll convert it to whatever format you want.
Originally Posted By: escanlan This post was automatically imported from our archived forum.
Wow! Thanks for the responses guys. The file being imported does not need to be protected. It is very large, 25MB. It is a list of all licensed Real Estate agents in the state of Texas and is available on the TREC WEB site. The site also contains a separate “File format” listing so I can set up the columns as needed.
In the master list each agent and all of their info is listed on one line, space delimited. I have the columns set no problem. But there are 136,000 line items. Excel only allows importing 65,536 line items per worksheet and will not span multiple sheets automatically. Instead it ends after the first worksheet, tells you to run the import wizard again and set the wizard to exclude any line items already imported on previous sheets. The problem is that requires a formula to be written, i.e. "If, Then,etc.".
The wife wound up doing it the long way, import then deleted the first 65,563 on the master list, import to a new sheet, delete the next 65,000, etc. The need is still there if you know a formula off the top of the cranium. I dislike manual work but have never been good at MS Office Automation programs.
Originally Posted By: escanlan This post was automatically imported from our archived forum.
High Jeff,
Yes I have Office Pro. My wife was going to work on a DB for this and use access. She had a lot of plans, and has used Access before but on a limited basis. I have used access before and for some things it is good but did not want to have to coach her on specifics and Exsmell for this particular use was quicker. At least until I ran into the worksheet size issue.
Originally Posted By: escanlan This post was automatically imported from our archived forum.
Hi Coleen,
I'll DL the file and give it to my wife to work with.
Access is straight forward. The problem that arises is when you create multiple DB's and later want to link with key fields and perform other operations. The older versions of access (I have not used anything from 2000 on) were a royal pain for record normalization, db linking, etc. Have not checked the new ones but given MS' record with their Office Automation products I really don't expect them to have made it much easier. Oracle has done a very nice job with this, offering many tools to help with the process. And since Oracle is so widely used many people have free homegrown programs to help.
Just as with any DB if you don't plan its use as far ahead as possible it really turns into a nightmare later. You can always go the route of specialized DB programs but get locked out of flexibility when you need it most. One of the reasons I was going to use Excel was if, in the future, I wanted to use the massaged list in a DB, or other program, just about everyone can either import the Excel spreadsheet directly or with minor gyrations.
Thanks for the help everyone! NACHI is certainly awesome on the help aspect!!!
Originally Posted By: Aimee Jalowsky This post was automatically imported from our archived forum.
I would also suggest www.openoffice.org, they have the same basic applications as Microscrewoff, but they are non Microscrewoff and work justas well. Not sure about how much info, but I haven’t had a problem yet, they have spreadsheets, databases, text docs, etc. I urge everyone to check it out!!! Did I mention its free?
Originally Posted By: escanlan This post was automatically imported from our archived forum.
Hi Aimee,
In my former life I was a UNIX/Linux engineer/administrator. I ran Red Hat on my desk top and used OpenOffice and loved it. I was also a Microscrew Certified Systems Engineer unfortunately. MS decided to create havoc for OpenOffice at one point. Although they have conceeded and are not intentionally causing issues the MS core still has some issues that create problems with OpenOffice and naturally MS won't address the issues.
But I will agree with you 100% that OpenOffice is a great suite!
-- Manny (Emmanuel) Scanlan
Knowledge is power, but sharing knowledge brings peace!
