If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|