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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i merge data stored in 4-5 worksheets into 1 file?
Hopefully you have Access. It is simple to use and, under the right
circumstances, is a good DB solution. Import each SS into a separate Access table, then use Append queries to load each of the tables into a single one. Access provides useful 'front end' capabilities. This DB is all the solution you will need if your data does not need to be exposed to multiple users and will store less 400-500K rows in the largest table. Those limits are my opinions about Access 2003 and are not an authoritative statement. The row limit may be subject to practical constraints due to your hardware. "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i merge data stored in 4-5 worksheets into 1 file?
Hi Kaushal
Use this to create a txt file http://www.rondebruin.nl/mergetotxt.htm And import it in Access -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Kaushal" wrote in message ... 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 |
Reply |
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 |