Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I merge two excel file data (no changes made to the file)? | Excel Discussion (Misc queries) | |||
how do you merge many files into one file with several worksheets? | Excel Discussion (Misc queries) | |||
Is it possible to merge data from two worksheets? | Excel Worksheet Functions | |||
Number stored as text: Frustrated with Excel-Word Merge | Excel Discussion (Misc queries) | |||
Merge Data From Multiple Worksheets | Excel Worksheet Functions |