another music database inquiry

[Brent_MN]

i am setting up a music database and I have a drop down box for the genre field, but I was wondering how to import CSV file into a table.....i am really new to access to i dont know if i need to explain more than that or what.........

also, i was wondering how one might setup something where you can click on something to display the lyrics of a particular song.....

one more thing, anyone know how to make it so when you click on a song it will open in winamp??

this is probably not as complicated as it sounds......thanks..

~Brent

 

[glynch]

You can import a csv file and create an Access table with it's data.
Here's how:

1. File menu, Get Eternal Data, Import... this will open the Import dialog box
2. At thbottom left hit the "files of type:" dropdown
3. Choose Text Files
4. Browse to or enter your csv file name
5. hit the Import button, this will open the Import Text Wizard
6. You can follow the steps in the wizard to choose field names, data types, etc. for your new table

Question 2:
You can have a Songs table with a song title field, and a memo field containing the lyrics. Have a combo box on a form that queries the Songs table, include both the title and lyrics fields in the query. Have the combo display the title field. Next to the combo box you can put a large text box, enter something like this into it's control source property: =ComboSongTitle.column(1)

The the fields in the rowsource of a combobox are zero based, so if the lyrics field was the second field in your Songs query it would be designated with a 1.

You can also have a field in your Songs table that is an OLE Object data type. Then you can link to existing objects like Word docs containing the lyrics for each song. Use the Insert menu, Object... to open a wizard to find and link to these docs.

You might be able to hold the music in a wav file and link to that thru an OLE Object field also, I have no experience with that though.

Hope this helps.

 

[Brent_MN]

thank you so much! i will give it a try......see if i can get everything to work.

 

[Graham T]

Brent

One more thing, anyone know how to make it so when you click on a song it will open in winamp??

Try this topic:

Winamp & Access

HTH