For SQL experts

[jurek2000]

To All SQL experts!!!

I have a huge amount of MP3 music . I have also installed SQL server recently and I would like to export the list of all of my music files to SLQ to have it sorted by author and title and maybe more for easy search .

What would be the easiest way to do that???

Thanx ,

Jurek

 

[tbuzz]

The easiest way

1. Prepare an ODBC datasource for your SQL server.
2. Open MS Access (big assumption, I know)
3. Go to File->Get External Data->Import
4. Select Text Files (another assumption) from the Files of Type Box (Choose alternate file type if needed)
5. Follow the wizard to describe your file
6. Save table in Access
7. Go to File->Save As/Export
8. Select To and External File or Database
9. Scroll all way to the bottom of 'Save as Type' drop down to select ODBC Databases
10. Name the table for your SQL server
11. Select the datasource you created in step 1.

Your done!

 

[jurek2000]

Thanx a lot for help , but how I can create that ODBC data source ? from my mp3 files .?

jurek

 

[DAM]

ODBC: go to start, setting, control panel, administrative tools. click on ODBC.





dam(assuming win2k)

 

[jurek2000]

I'm doing it first time and I still don't really understand how to import that mp3 files because I don't want to import the all files . I need to convert those files somehow to text so I have just artists and titles .

 

[joinT]

<< dam(assuming win2k) >>


LMAO that's great

d00d, make a playlist in winamp with every song &amp; rename it to .txt
then you have all the stuff in text format

 

[jurek2000]

It will take me forever to do that because I have aroung 10.000 songs.

 

[Hector13]

<< It will take me forever to do that because I have aroung 10.000 songs. >>



SQL Server (or even access) seems like a huge overkill for this. Just out of curiousity, why are you doing this?

Since it doesn't seem like you know how to use DTS (or even setup an ODBC source), I am assuming you don't know SQL very vell. SQL Server (unlike access) doesn't really have an easy to use front end, thus you need to use SQL to do anything meaningful with the data. It is not like Excel or Access where you can just play with the data.

I think you are much better of searching some MP3 sites for software that will do exactly what you want (ie, catalog your files). If you can't find anything, check on some IRC channels, those people use tools to pump out text files of all their songs (including ID3 tags) for use with fserves. I am sure you can use one to have the data in a form that can be used by SQL server, Access, or any other db software.

 

[Workin']

You are way over your head using SQL Server to do this if you can't even figure out a way to get a list of your mp3's and their associated information. That is child's play considering how much fun SQL Server is to learn. That RDBMS is meant for enterprise-level work, and takes real skill and effort to use. It is especially ill-suited as a dektop application. If you don't know what ODBC is then you have an even tougher row to hoe, because that means you probably don't even know a tiny fraction of what's necessary.

Access would be much better suited and easier to learn, assuming you have that. There are programs out there that will extract the ID3 tag data from the mp3 file and save it as text, then you could import that into Access.

 

[jurek2000]

<<

<< It will take me forever to do that because I have aroung 10.000 songs. >>



SQL Server (or even access) seems like a huge overkill for this. Just out of curiousity, why are you doing this?


The reason I'm doing this is that I want to learn SQL.

 

[KeyserSosa]

There is a lot of useful SQL info located at Sitepoint for those just learning and for advanced users. I'm just learning it myself and found it very useful.