Snail Posted October 17, 2005 Report Share Posted October 17, 2005 I have this spreadsheet with all my MP3 files in. It has a worksheet for each backup DVD, then each worksheet contains artist, track title, etc. What i want to do, is find some way of automatically creating an access database, with all the stuff from the spreadsheet in it. Can anyone give me a clue? Cheers in advance Link to comment Share on other sites More sharing options...
s4dreamer Posted October 17, 2005 Report Share Posted October 17, 2005 Can't help you on Access specifics Snail, but most modern db's will allow you to import a CSV format file. So, simply dump out your spreadsheet in CSV, then figure out the Access magic to load it into the db (after you've created the tables, probably). Link to comment Share on other sites More sharing options...
Snail Posted October 17, 2005 Author Report Share Posted October 17, 2005 Well, been playing with access, and if i just open my excel file with access, it creates a new database, with all the info in. I need to import each worksheet seperately, but thats not that much hassle. Quite impressed with the ease of it actually. Link to comment Share on other sites More sharing options...
R32North Posted October 17, 2005 Report Share Posted October 17, 2005 [ QUOTE ] Well, been playing with access, and if i just open my excel file with access, it creates a new database, with all the info in. I need to import each worksheet seperately, but thats not that much hassle. Quite impressed with the ease of it actually. [/ QUOTE ] But doesn't necessarily build the relationships to allow you to make it relational, ie One album = many songs = one artist, etc Link to comment Share on other sites More sharing options...
scooby_simon Posted October 17, 2005 Report Share Posted October 17, 2005 [ QUOTE ] [ QUOTE ] Well, been playing with access, and if i just open my excel file with access, it creates a new database, with all the info in. I need to import each worksheet seperately, but thats not that much hassle. Quite impressed with the ease of it actually. [/ QUOTE ] But doesn't necessarily build the relationships to allow you to make it relational, ie One album = many songs = one artist, etc [/ QUOTE ] [anal retentive mode on] Don't you mean Album = disc(s) = song(s) = artist(s) 1:many(at least one):many(at least one):many(at least one):many(at least one) etc..... [/off] Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now