how to import data from data base in MsExcel?

Answer 1

Click DATA, then IMPORT DATA

Answer 2

Control Panel > Administrative Tools > Data Sources (ODBC)

Under System DSN click Add...

If your database is Microsoft SQL, wcroll all the way to the bottom and select SQL Server.

Click Finish.

Next window, give it a name and description of whatever you want. (Something recognizable. Ex. Employee DB on Wizard server)

Select the SQL server from the drop down list. Click Next.

Select the database you want to connect to from the drop down.

Click Next until you finish adding. No need to change other settings, defaults should be fine. If you have permissions to the db, test the connection to the DB.

Open Excel.

Data > Import External Data > Import Data ...

Change file of type to ODBC File DSNs

Select the DSN fro m the box that you just created.

Answer 3

Dump the database or table data to a file using the following command

If you want to dump database then issue this command
> mysqldump -uroot -pabc12 db_name > dumpFile.sql

If you want to dump a table then issue this command
> mysqldump -uroot -pabc12 db_name tab_name > dumpFile.sql

Here username and password is as an example

Then in excell
Tools > Import external Data> select the dump file > and import data.

Thats all

Answer 4

As cautioned, export/import it as a comma delimited (.csv) document. although, as additionally cautioned, you will ought to filter out the information interior the database all the way down to no greater beneficial than sixty 5,536 archives - the optimum selection Excel can handle. I had a similar situation doing archives diagnosis at BT - we frequently began by importing a pair of million products of uncooked archives into get entry to and then filtering out approximately 95% of them! playstation . I relatively have because discovered that the hot Excel 2007 can handle over a million archives.

Answer 5

Hello kasish

Answer 6

how