How can you get data from a database in an Excel sheet?
- 1 Answers
- 1148 Views
- MindCracker, I also Faced
- E-Mail Answers
Answer / Sumit Kumar Singh
You can export data from a database into an Excel sheet using various methods, such as SQL queries (e.g., SELECT INTO EXCEL), tools like `db2look` or `bcp`, or by using software like Microsoft Access or Power Query to connect directly to the database and import data.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are records and fields in a database?
What is dbms language?
How is a database related to a table?
What is acid property in dbms?
write a query to Find the Maximun second value in table?
What do you mean by denormalization?
What is data independence and also explain its types?
What is trigger in dbms?
Explain 3nf?
What's difference between dbms and rdbms ?
What's the difference between delete and truncate ?
Define scalar functions.
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
