View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kaushal Kaushal is offline
external usenet poster
 
Posts: 1
Default How do i merge data stored in 4-5 worksheets into 1 file?

Hi,

I have a couple of excel files with more than 3.5 to 4 lakh row details
entered in 4-5 different excel worksheets. I am unable to keep all the data
in 1 file as excel is limited to a max. of 65536 row records per excel
worksheet. Is there any way that i can migrate all the data in 1
database/file and run queries on the same? Please help me in solving this
asap. Also give me some suggessions/ideas as to what database would be
recommended at the backend and what application software would result in
better connectivity for frontend...


Thanks & Regards,
Kaushal