So the data is in Excel, but Excel will not display any rows exceeding the 65,536th row. Apparently you can retrieve through a compatibility checker, but it is foreign to me. Can you please offer exact step by step directions for performing such a task? Thanks.
2007-03-01 00:58:06 · 2 answers · asked by jon 2 in Computers & Internet ➔ Software
If Access is not an option for you, then I suggest you split the original file before importing it into Excel. Import onto multiple sheets if you have to, but that makes filtering more complex. Also, if you are not using that many columns, you can later move the seconds sheet's info onto the first sheet so that you have two sets of data on one sheet. This is not ideal but it is a work around. New Excel 2007 gives you a million or so rows whereas Quattro has been doing it for ages.
2007-03-01 15:42:20 · answer #1 · answered by Anonymous · 0⤊ 0⤋
You can put the data in access and query it with excel or within access of course.
2007-03-01 06:41:43 · answer #2 · answered by unnga 6 · 0⤊ 0⤋