Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does Excel 2000/2003 have a max number of records like '98 has?
I'm trying to import data from Crystal reports to Excel then to Access. The
Crystal report has over 85000 records but Excel only allows 65585ish records on sheet 1 and the rest on sheet 2. Would I have the same problem with 2000/2003? Any ideas how I can make this work with Office €˜98? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does Excel 2000/2003 have a max number of records like '98 has?
Yes, the limitation is the same in those versions. It changes in Excel 2007.
HTH. Best wishes Harald "nobfelt" skrev i melding ... I'm trying to import data from Crystal reports to Excel then to Access. The Crystal report has over 85000 records but Excel only allows 65585ish records on sheet 1 and the rest on sheet 2. Would I have the same problem with 2000/2003? Any ideas how I can make this work with Office '98? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does Excel 2000/2003 have a max number of records like '98 has
export it as a csv file then open/import it in access
"Harald Staff" wrote: Yes, the limitation is the same in those versions. It changes in Excel 2007. HTH. Best wishes Harald "nobfelt" skrev i melding ... I'm trying to import data from Crystal reports to Excel then to Access. The Crystal report has over 85000 records but Excel only allows 65585ish records on sheet 1 and the rest on sheet 2. Would I have the same problem with 2000/2003? Any ideas how I can make this work with Office '98? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search for number in excel | Excel Discussion (Misc queries) | |||
Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) | |||
How to combine Excel 2002 files and remove duplicate records? | New Users to Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |