How do i merge data stored in 4-5 worksheets into 1 file?
For that many records, I would suggest using Microsoft Access. Simple man's
version, you could just create a table in Access to store the information,
and then pull required information from Access to Excel via SQL queries.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Kaushal" wrote:
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
|