| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 80035 | 2007-06-09 08:02:00 | Excel 2003 not opening all of my business CSV file | Neil McC (178) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 557605 | 2007-06-09 08:02:00 | that I download each month from one of my suppliers.I usually use a program to do my invoicing and import the price list into that program.Am looking at just using Cashbook (and saving $500.00 a year) and selecting the item I want from Excel to copy into Cashbook.But Excel wont open the whole file.About 50,000 items I think.Stops about the R's! Any suggestions on a program to open the CSV file, please.Or how to enable Excel to do it. Thanks. |
Neil McC (178) | ||
| 557606 | 2007-06-09 08:26:00 | if I remeber correctly you can import csvs into a access data base as a linked table then all you have to is run a query to extract selected data then export that from access to a csv for importing back into your accounting program. | beama (111) | ||
| 557607 | 2007-06-09 09:14:00 | Thanks beama.I don't understand all you said,but managed to open it in Access using the wizard!! That had A to Z in it,so that's great. Thanks. |
Neil McC (178) | ||
| 557608 | 2007-06-10 11:26:00 | Hi Neil I suspect you hit the 65k row limit in Excel? That's why you can see it in Access but not Excel - Access doesn't have that limit. Andrew |
andrew93 (249) | ||
| 557609 | 2007-06-10 11:29:00 | Excel 2007 allows over 1 million lines in the native format, I regularly parse files with 800,000 lines. Beats access for speed of sorting and file splitting for me. |
godfather (25) | ||
| 557610 | 2007-06-11 01:08:00 | Check you havent got and 'comma's' in the csv either......... | SolMiester (139) | ||
| 557611 | 2007-06-11 02:22:00 | I think you're right Andrew.Access shows 85,700 items. Thanks gf, I don't want to fork out any more to Mr Gates just yet!!But Access does do a very slow search. Real pain. SolMiester,can you explain a little more what you mean,please. Any suggestions on a free program that will open big csv files with a good search in it? |
Neil McC (178) | ||
| 557612 | 2007-06-11 07:42:00 | never tried it, but you could try grep for windows. | beama (111) | ||
| 557613 | 2007-06-11 10:02:00 | Hi Neil If you set up the table in Access with the appropriate field names and data types, you can then add indexes to that table and I would expect the searches would be much quicker. If you want to experiment with the table settings then have a look at the table design. Andrew P.S. And once the table has been set up correctly, then future imports would be into that table with the indexes etc already set up. |
andrew93 (249) | ||
| 557614 | 2007-06-13 20:55:00 | Hi Neil If you set up the table in Access with the appropriate field names and data types, you can then add indexes to that table and I would expect the searches would be much quicker. If you want to experiment with the table settings then have a look at the table design. Andrew P.S. And once the table has been set up correctly, then future imports would be into that table with the indexes etc already set up. Thanks beama,I think that's a bit over my head!! Thanks Andrew, I'll have a play around. Tried Open Office but that has the same limitations as Office 2003. |
Neil McC (178) | ||
| 1 2 | |||||