How to import data from database to excel?

[naga_indhra]

Here the database may be a text format or any other

[Solly NOR♦CAL R&S]

You need to setup an ODBC connection to the datasource, and then import your data it into Excel using MSQuery.There are other techniques, but that is the most straightforward, and will allow you to refresh the spreadsheet without having to use the import-wizard each time.You can IM me for the next 30 minutes or so, and I'll try to help you.

[Liu Z]

open the excel and then find the menu:import.you can choose the text file and follow the guide.