How do i merge data stored in 4-5 worksheets into 1 file?

[Kaushal]

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

 

[Luke M]

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.

 

[mklapp]

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.

 

[Ron de Bruin]

Hi Kaushal

Use this to create a txt file
http://www.rondebruin.nl/mergetotxt.htm

And import it in Access