How can i open a csv file having more that 65536 rows ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a csv file which is having more than 65536 rows . When i open it
in excel it shows records only upto 65536 rows and also it gives error
 
Kuldeep,

Are you posting this question here on purpose? This seems to be an Excel
question, while the answer is "use Access to do it", so I'm not sure if
the choice of newsgroup was intentional or just luck. Anyway... In
Access, use the wizard in File > Get External Data > Import to import
the data in a table; Access does not have Excel's limit of 65536 rows,
so it should solve your problem.

HTH,
Nikos
 
Back
Top