Windows 10: Convert EXCEL sheets to MySql / MariaDB with links to music

Hi folks
I'm trying to create a decent Music Database

Basically rather than messing around with zillions of files / tracks / playlists etc I want to use one of the Free database systems (MySQL / MariaDB - both similar and work on Windows).

I have a load of spreadsheets -- what I want basically to start testing (can add other fields later) is for Album title, file / track name and path where the link will be able to link directly to the music track and application will play the file

Using this type of database I can then create my own queries if I want specific music etc

Once you get 1 TB or more of music data using traditional libraries / playlists etc doesn't really cut it any more

For the spreadsheets I used Mp3tag to save as csv, imported into excel where the ';' character is used as mp3tags delimiter and now I want to import these spreadsheets into MySQL -- not sure though how to handle the binary objects (the music files)

Here's a typical spreadsheet I want to import into the DB.





Any ideas anyone

From the sample spreadsheet shown above -- just a small test to start with say 3 or 4 fields in the DB would be fine -- I can expand later -- what I need is the best way of handling the binary files - MariaDB or MySQL are so similar - either will do.

I don't want proprietary systems - most music type libraries - especially for consumer stuff usually break quite often and have problems if they expand over several disks or you swap disks around. MySQL / MariaDB are open source and robust so no probs there.

Any DBA's out there -- probably simple - 90 secs work for you gurus. !!


Cheers
jimbo

:)

 

i have a problem with MySQL on my laptop windows 10 bit 64

first of all, i mistakenly typed "sc delete mysql" in the command prompt because my Xampp mysql is not responding.

Later, i uninstall Xampp and reinstall it again and MySQL started working. so i uninstall Mariadb and reinstall it again. While installing Mariadb, it stopped and displayed a message saying "service "MySQL"
(MySQL) failed to start. Verify that you have sufficient privileges to start system services." i would like you to help me solve this problem. Thank you.

 

Storing Pictures in Excel Sheet

Hi Now,



I posted the following on the MSDN Excel forum, and the answer was that the suggested method (in particular the VBA) is not available.

But perhaps there is another way to accomplish the task?

I would be ever so thankfull for a good suggestion



Jos



PS: A have experience with VBA, VBScript



---- previously posted:



Hi,

My boss wants me to buy a PDA with Windows Mobile 6. The customer sends a

"normal" Excel-sheet of objects to be inspected. After loading into to PDA

the workers have to take a picture of objects that fail inspection. The

picture then has to be linked to the Mobile-sheet by means of a hyperlink.

I think this is possible used a bit of VBA in Excel, but does Excel Mobile

support VBA?

--

Jos



Answer something like,



I think a no to that.

 

EXCEL SHEET IN MAP XML FILE DELETE IN EXCEL SHEET

EXCEL SHEET IN MAP XML FILE SO EXCEL SHEET WORKING NO PROPERLY SO I HAVE DELETE XML MAP IN EXCEL SHEET