Hi,

I need to export data from two seperate tables in database to the same sheet in excel. ie, the data from the tables should appear one below the other in the same sheet of excel.

Could any one tell me how this can be made possible.Also could any one tell me whether it is possible to format the cells of the resulting excel.


Thanks in advance,
Aswathy

Can't you just create a report file in the form you want it, and then import that.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.