by ZeusRex » Tue Oct 05, 2004 9:19 am
Here's a solution that I put in another post.
Copy and paste this into Notepad:
XLODBC
1
DSN=MediaMonkey;DBQ=D:\My Music\MediaMonkey\MediaMonkey.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;
SELECT Albums.*, Artists.*, Songs.*, Genres.*, Medias.*, Memos.* FROM (Medias INNER JOIN (((Albums INNER JOIN Artists ON Albums.IDArtist = Artists.ID) INNER JOIN Songs ON Albums.ID = Songs.IDAlbum) INNER JOIN Genres ON Songs.Genre = Genres.IDGenre) ON Medias.IDMedia = Songs.IDMedia) INNER JOIN Memos ON Songs.ID = Memos.IdSong;
Replace the file name "D:\My Music\MediaMonkey\MediaMonkey" with the name of your MM database. It will probably be in a different location.
Save the file as "SelectAll.DQY". The .DQY extention is for query files for Excel.
Close Notepad and double-click the SelectAll.dqy file. It should open in Excel. A dialog should open saying that no data connection could be made. No problem. Click OK and another dialog will open, "Select Data Source". Click New -> User Data Souce -> Next -> Select Microsoft Access Driver -> Next -> Finish. A new dialog will open called ODBC Microsoft Access Setup.
For the Data Source Name, enter "MediaMonkey". Then click "Select", and browse for your MM database. Once it shows in the lefthand panel, select it and click OK. You've now created the database connection.
Click OK to the Select Data Source Window, and OK to the Login Panel. The results of the query should appear in Excel.
If all works you should have almost all of the data from MediaMonkey on the spreadsheet.
Now, you can format the information how you want it. In Excel, click Data -> Import External Data -> Data Range Properties. In the dialog, select "Refresh Data on File Open" and "Remove external data from worksheet before saving". This will clear the spreadsheet of all data when you save it and refresh the data everytime you open it. Always up to date. Also be sure that Preserve Column Sort and Preserve Cell Formatting are selected. Close the dialog.
Now, you can hide some columns (you'll probably have lots of irrelevent data), and put the columns in the order you want.
Save the spreadsheet. Everytime you open it now it will load the query and the data from MM.
Hope this works for you.
Here's a solution that I put in another post.
Copy and paste this into Notepad:
XLODBC
1
DSN=MediaMonkey;DBQ=D:\My Music\MediaMonkey\MediaMonkey.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;
SELECT Albums.*, Artists.*, Songs.*, Genres.*, Medias.*, Memos.* FROM (Medias INNER JOIN (((Albums INNER JOIN Artists ON Albums.IDArtist = Artists.ID) INNER JOIN Songs ON Albums.ID = Songs.IDAlbum) INNER JOIN Genres ON Songs.Genre = Genres.IDGenre) ON Medias.IDMedia = Songs.IDMedia) INNER JOIN Memos ON Songs.ID = Memos.IdSong;
Replace the file name "D:\My Music\MediaMonkey\MediaMonkey" with the name of your MM database. It will probably be in a different location.
Save the file as "SelectAll.DQY". The .DQY extention is for query files for Excel.
Close Notepad and double-click the SelectAll.dqy file. It should open in Excel. A dialog should open saying that no data connection could be made. No problem. Click OK and another dialog will open, "Select Data Source". Click New -> User Data Souce -> Next -> Select Microsoft Access Driver -> Next -> Finish. A new dialog will open called ODBC Microsoft Access Setup.
For the Data Source Name, enter "MediaMonkey". Then click "Select", and browse for your MM database. Once it shows in the lefthand panel, select it and click OK. You've now created the database connection.
Click OK to the Select Data Source Window, and OK to the Login Panel. The results of the query should appear in Excel.
If all works you should have almost all of the data from MediaMonkey on the spreadsheet.
Now, you can format the information how you want it. In Excel, click Data -> Import External Data -> Data Range Properties. In the dialog, select "Refresh Data on File Open" and "Remove external data from worksheet before saving". This will clear the spreadsheet of all data when you save it and refresh the data everytime you open it. Always up to date. Also be sure that Preserve Column Sort and Preserve Cell Formatting are selected. Close the dialog.
Now, you can hide some columns (you'll probably have lots of irrelevent data), and put the columns in the order you want.
Save the spreadsheet. Everytime you open it now it will load the query and the data from MM.
Hope this works for you.
