Converting SQL 7 Database to Excel

40 pts.
Tags:
Microsoft Excel
SQL
SQL 7
SQL to Excel Database Conversion
Hi,

I would like to know any possible way of converting my Sql 7 Database to Excel formats.

Any ideas anyone.

Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

Yes you can convert mysql 7 database to excel.

Create a csv (comma seperated file) and open in excel format u can do it.

From: CHatmaker
Hi Bertski

Javaram’s answer works great if you are downloading for your own use. If you are trying to provide something to an “end user”, the approach in my blog will help greatly. Give it a shot:

http://itknowledgeexchange.techtarget.com/beyond-excel/

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jayaram
    hope u can do that. if not pl. revert for more information
    140 pointsBadges:
    report
  • Denny Cherry
    You can export the data from each table to an excel sheet. You can't query an Excel sheet like you can a database so you can't get the same functionally from the Excel sheet that you can from the database.
    66,085 pointsBadges:
    report
  • Bertski
    I support 100% Mrdenny's underlying premise that Excel cannot and should not be a substitute for a database - but it is quite possible to query/run SQL over an Excel Sheet. Check your "ODBC Data Source Administrator" in your control panel under "Administrative Tools" and you will find some or all of the following drivers: Driver do Microsoft Excel(*.xls) Microsoft Excel Driver (*.xls) Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) You can use them with MS Query (or any ODBC compliant tool) to retrieve, filter, sort, sum, etc. any lists in any Excel spreadsheet.
    0 pointsBadges:
    report
  • DoneThat
    I have working apps using SQL (via MS Office VBA) to access Excel sheets. Just be aware that the "dialect" of SQL for Excel is severely limited & has a lot of gotchas.
    830 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following