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

Asked By 30 points N/A Posted on -
qa-featured

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

How can I do that?

SHARE
Best Answer by Alcaraz Jody
Answered By 0 points N/A #153099

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

qa-featured

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.

 

Best Answer
Best Answer
Answered By 0 points N/A #153100

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

qa-featured

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.

Login/Register to Answer

Related Questions