danap_n_mt
June 7th, 2009, 09:05 PM
The following often appears as a link to the MyJSQLView project
from the Ubuntu Forum in of June 2007 and I would like to answer.
At the time MyJSQLView may not of been able to pull in a .xls
sheet, but it does now. Just save it as .csv text format then
import. MyJSQLView will either insert or update the data provided
you have a database table created with the proper fields.
danap.
> MySQL Editor? What's good for a beginner?
> I just ran across this http://myjsqlview.sourceforge.net/
> and was wondering if anyone has experience with other SQL
> editors for complete n00bs.
> Basically I am looking to be able to take an .xls sheet,
> edit it, and convert the output to integrate into an existing
> SQL database, to be managed online via myPHPadmin.
> Any suggestions would be greatly appreciated
from the Ubuntu Forum in of June 2007 and I would like to answer.
At the time MyJSQLView may not of been able to pull in a .xls
sheet, but it does now. Just save it as .csv text format then
import. MyJSQLView will either insert or update the data provided
you have a database table created with the proper fields.
danap.
> MySQL Editor? What's good for a beginner?
> I just ran across this http://myjsqlview.sourceforge.net/
> and was wondering if anyone has experience with other SQL
> editors for complete n00bs.
> Basically I am looking to be able to take an .xls sheet,
> edit it, and convert the output to integrate into an existing
> SQL database, to be managed online via myPHPadmin.
> Any suggestions would be greatly appreciated