How do I extract data from database file to .xls file?

Asked By casey cock 30 points N/A Posted on - 11/20/2012

I have some important data in my database and need to extract it immediately to .xls file.

How can I do that?

• Status: Open
• Question Views: 910
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: DB Reporting Tools

Best Answer by Alcaraz Jody

Go To Solution

Answered By Deborah Antoaneta 0 points N/A #153099

How do I extract data from database file to .xls file?

Hi!

Do the Select Into Outfile syntax. It will let you make a CSV file where it will become readable by Excel.

But you have to remember to name it as .cs since .xls is not supported by some open source applications.

And you can import CSV files compatible with the database in Excel.

 

About Deborah Antoaneta

Questions
3

Answers
81

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 11/20/2012
• Question Category: DB Reporting Tools

Best Answer

Best Answer

Answered By Alcaraz Jody 5 points N/A #153100

How do I extract data from database file to .xls file?

Dear Casey cock,

You can import data from database to Excel file by following these steps:

1. Open a new excel file.

2. Click on data tab from the above menu and select get external data.

3. From the external data menu select from access.

4. A new window will open then browse through it to open your database.

5. Then after selecting your database a new window appear for adjusting the format of your data in the excel file.

6. You have your data copied into excel sheet.

About Alcaraz Jody

Questions
2

Answers
100

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 12/21/2012
• Question Category: DB Reporting Tools