Skip to main content
gamedev.net
🔒 Locked

SQL and EXCEL

Started by Xpyder 1 reply 400+ views
Original Post
Xpyder
Xpyder
if i had a php form, outputting the results to a sql database, could i download tht file and open it in excel?
JUST-CODE-IT.NETManaged DirectX & C# TutorialsForumsArticlesLinksSamples
Michalson
Michalson
What kind of SQL database? SQL is a language for interacting with databases, not a database in itself. If you are using say, SQL Server, you can use Enterprise Manager to export a table or query as an Excel spreadsheet.
mrbastard
mrbastard
your best bet would be to use php to output comma seperated values (.csv). Should be pretty simple to write in php, and Excel imports csv fine. If you use mysql, phpmyadmin will export csv for you (even the slightly mysteriously titled 'csv for ms excel data').
[size="1"]

Topic Locked

This topic has been locked by a moderator. New replies are not allowed.

Sign in to reply to this topic.