Just wondering if it would be possible to export tag data directly into a, for example, MS SQL database? I am able to export an XML file, but I have not found an easy way to import XML to SQL, so I wanted to try and save a step 
Cheers,
Drew
Hi,
You would have the overhead of the XML to process, so the easiest way would be to create CSV file(s) and import them methinks.
Daz
Well ... I think ... yes you can .. there is a way to SQL.
Since Mp3tag exports all data in text mode, you are able to write an export script which has the format of a SQL table dump. Afterwards you can create a SQL database from this dump file.
There might be other possibilities to write a SQL insert script or such alike.
Here is an example Mp3tag export script.
$filename(F:\TEMP\Mp3tag.sql.txt,UTF-8)
'PRAGMA foreign_keys=OFF;'
'BEGIN TRANSACTION;'
'CREATE TABLE tbl1(Title varchar(20), Track smallint);'
$loop(%TITLE%)
'INSERT INTO "tbl1" VALUES("'%TITLE%'"',$if2(%TRACK%,0)');'$loopend()
'COMMIT;'
Using sqlite3.exe you can create a sql database from the Mp3tag export text file on the command line:
TYPE "F:\TEMP\Mp3tag.sql.txt"|sqlite3.exe TestDB
Some output on the command line looks like:
F:\TEMP>ECHO.select * from tbl1;|sqlite3.exe TestDB
abc def ghi (JKL mNo pQ) rst uvw xyz|11
Ambivalence Avenue|1
Daydreamer|1
Lovin' You [Europe / Oz 4 Trk]/Europe / Oz 4 Trk|0
Song Name - Adele - Album|1
Hope this points you into the right direction.
DD.20100114.1122.CET