Does anyone here know how to do the following:
I have data inside an Sql database (MySQl, workbench). I can export it into an excel sheet. Then I can simply save it on my desktop. Pretty straight forward.
But my question is: How do I have an automatic link between the two? Lets say... I have added a new line inside an excel sheet and vice versa. how would the two communicate together and send relevant data to mirror each others data?
I would not recommend doing this. For data security and integrity's sake.
However, if you want to, you can export out data from Excel to csv or some other format. then run script on MySQL side to import.
Typically it's more secure to do this rather than pushing data from Excel side.
Have a read of...
http://www.mysqltutorial.org/import-...e-mysql-table/
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thanks CK76 ill have a read now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks