pmcinvest
12-23-2006, 06:36 PM
After several days beating my head against the wall, not getting the answer I needed from the forum or support, I stumbled on an interesting source of programs for working with mySQL (and many other things as well)
I had been trying to link an Excel spreadsheet to my db without success. I could export a txt file and link Excel to the txt file. I could run a php page to create an xls file on my harddrive. Neither of these were practical. A direct ODBC link could not be established. (I later confirmed that I had been entering all the correct information but the link still failed for reasons I still do not know)
The site is http://www.sobolsoft.com/ . I tried both the SQL/Access and the SQL/Excell demos and was able to link to my db with each one. The full versions cost about $30 but if they save me 3 days of grief, its worth it. Both demos seem to facilitate downloading and uploading from and to the database but not a live interface.
Another front-end GUI for SQL (I've learned that's what I've been trying to create): http://www.webyog.com/en/ Tried out the free non-commercial version. Much better look and feel to the program. Also it does allow a live connection. Edits made in the GUI show up almost immediately (a few seconds) in the db without any file conversion, upload or action by the user. The full enterprise version was about $40 or so.
Let me know what you think of them.
I had been trying to link an Excel spreadsheet to my db without success. I could export a txt file and link Excel to the txt file. I could run a php page to create an xls file on my harddrive. Neither of these were practical. A direct ODBC link could not be established. (I later confirmed that I had been entering all the correct information but the link still failed for reasons I still do not know)
The site is http://www.sobolsoft.com/ . I tried both the SQL/Access and the SQL/Excell demos and was able to link to my db with each one. The full versions cost about $30 but if they save me 3 days of grief, its worth it. Both demos seem to facilitate downloading and uploading from and to the database but not a live interface.
Another front-end GUI for SQL (I've learned that's what I've been trying to create): http://www.webyog.com/en/ Tried out the free non-commercial version. Much better look and feel to the program. Also it does allow a live connection. Edits made in the GUI show up almost immediately (a few seconds) in the db without any file conversion, upload or action by the user. The full enterprise version was about $40 or so.
Let me know what you think of them.