by gvmsia » Fri Jun 14, 2013 10:38 am
pls help, this is a sample of my Excel database that i converted to text. Can I know what to do next, to get it to be imported into MM columns columns "Custom 1", "Album", "Track#", "Title", "Artist"?
sample:
Code: Select all
FileNumber,Album,TrackNumber,Title,Artist
A0001,Everyday,1,I Did It,Dave Matthews Band
A0001,Everyday,2,When The World Ends,Dave Matthews Band
A0001,Everyday,3,Space Between,Dave Matthews Band
A0001,Everyday,4,Dreams Of Our Fathers,Dave Matthews Band
A0001,Everyday,5,So Right,Dave Matthews Band
A0001,Everyday,6,If I Had It All,Dave Matthews Band
A0001,Everyday,7,What You Are,Dave Matthews Band
A0001,Everyday,8,Angel,Dave Matthews Band
A0001,Everyday,9,Fool To Think,Dave Matthews Band
A0001,Everyday,10,Sleep To Dream Her,Dave Matthews Band
A0001,Everyday,11,Mother Father,Dave Matthews Band
A0001,Everyday,12,Everyday,Dave Matthews Band
A0002a,Woodstock 94 (Disc 1),1,Selling The Drama,Live
A0002a,Woodstock 94 (Disc 1),2,But Anyway,Blues Traveler
A0002a,Woodstock 94 (Disc 1),3,I'm The Only One,Melissa Etheridge
A0002a,Woodstock 94 (Disc 1),4,Feelin' Alright,Joe Cocker
A0002a,Woodstock 94 (Disc 1),5,(Stage Announcement),Woodstock 94
A0002a,Woodstock 94 (Disc 1),6,Dreams,Cranberries
A0002a,Woodstock 94 (Disc 1),7,Soup,Blind Melon
A0002a,Woodstock 94 (Disc 1),8,When I Come Around,Green Day
A0002a,Woodstock 94 (Disc 1),9,Shoop,Salt-N-Pepa
A0002a,Woodstock 94 (Disc 1),10,(Stage Announcement),Woodstock 94
A0002a,Woodstock 94 (Disc 1),11,Blood Sugar Sex Magik,Red Hot Chili Peppers
A0002a,Woodstock 94 (Disc 1),12,Porno For Pyros / Porno For Pyros,Porno For Pyros
A0002a,Woodstock 94 (Disc 1),13,Those Damned Blue-Collar Tweekers,Primus
A0002a,Woodstock 94 (Disc 1),14,Headed For Destruction,Jackyl
A0002a,Woodstock 94 (Disc 1),15,Draw The Line / F.I.N.E.,Aerosmith
A0002a,Woodstock 94 (Disc 1),16,(Stage Announcement),Woodstock 94
A0002a,Woodstock 94 (Disc 1),17,Happiness In Slavery,Nine Inch Nails
A0002b,Woodstock 94 (Disc 2),1,For Whom The Bell Tolls,Metallica
A0002b,Woodstock 94 (Disc 2),2,The Hunter,Paul Rodgers Featuring Slash Jason Bonham Neil S
A0002b,Woodstock 94 (Disc 2),3,Come Together,Neville Brothers
A0002b,Woodstock 94 (Disc 2),4,Run Baby Run,Sheryl Crow
A0002b,Woodstock 94 (Disc 2),5,Deja Vu,Crosby Stills & Nash
A0002b,Woodstock 94 (Disc 2),6,Dance M.F. Dance - Kiss Off,Violent Femmes
A0002b,Woodstock 94 (Disc 2),7,Shine,Collective Soul
A0002b,Woodstock 94 (Disc 2),8,Arrow,Candlebox
A0002b,Woodstock 94 (Disc 2),9,How I Could Just Kill A Man,Cypress Hill
A0002b,Woodstock 94 (Disc 2),10,Right Here Too Much,Rollins Band
A0002b,Woodstock 94 (Disc 2),11,Highway 61,Bob Dylan
A0002b,Woodstock 94 (Disc 2),12,Pearly Queen,Traffic
A0002b,Woodstock 94 (Disc 2),13,Biko,Peter Gabriel
A0003,Essential Eighties 1,1,Call Me,Blondie
A0003,Essential Eighties 1,2,Turning Japanese,Vapours
A0003,Essential Eighties 1,3,Bette Davis Eyes,Kim Carnes
A0003,Essential Eighties 1,4,Centerfold,J. Geils Band
A0003,Essential Eighties 1,5,Always Something There To Remind Me,Naked Eyes
A0003,Essential Eighties 1,6,Power Of Love,Huey Lewis & The News
A0003,Essential Eighties 1,7,Let's Go All The Way,Sly Fox
A0003,Essential Eighties 1,8,French Kissin' In The Usa,Deborah Harry
A0003,Essential Eighties 1,9,Don't Worry Be Happy,Bobby McFerrin
A0003,Essential Eighties 1,10,Down On The Border,Little River Band
A0003,Essential Eighties 1,11,Everywhere I Go,Qed
A0003,Essential Eighties 1,12,Love At First Sight,Kim Hart
A0003,Essential Eighties 1,13,Don't Forget Me (When I'm Gone),Glass Tiger
A0003,Essential Eighties 1,14,Man Overboard,Do-Re-Mi
A0003,Essential Eighties 1,15,Cry In Shame,Jonny Diesel & The Injectors
A0003,Essential Eighties 1,16,Somethings Gotton Hold Of My Heart,Marc Almond & Gene Pitney
pls help, this is a sample of my Excel database that i converted to text. Can I know what to do next, to get it to be imported into MM columns columns "Custom 1", "Album", "Track#", "Title", "Artist"?
sample:
[code]FileNumber,Album,TrackNumber,Title,Artist
A0001,Everyday,1,I Did It,Dave Matthews Band
A0001,Everyday,2,When The World Ends,Dave Matthews Band
A0001,Everyday,3,Space Between,Dave Matthews Band
A0001,Everyday,4,Dreams Of Our Fathers,Dave Matthews Band
A0001,Everyday,5,So Right,Dave Matthews Band
A0001,Everyday,6,If I Had It All,Dave Matthews Band
A0001,Everyday,7,What You Are,Dave Matthews Band
A0001,Everyday,8,Angel,Dave Matthews Band
A0001,Everyday,9,Fool To Think,Dave Matthews Band
A0001,Everyday,10,Sleep To Dream Her,Dave Matthews Band
A0001,Everyday,11,Mother Father,Dave Matthews Band
A0001,Everyday,12,Everyday,Dave Matthews Band
A0002a,Woodstock 94 (Disc 1),1,Selling The Drama,Live
A0002a,Woodstock 94 (Disc 1),2,But Anyway,Blues Traveler
A0002a,Woodstock 94 (Disc 1),3,I'm The Only One,Melissa Etheridge
A0002a,Woodstock 94 (Disc 1),4,Feelin' Alright,Joe Cocker
A0002a,Woodstock 94 (Disc 1),5,(Stage Announcement),Woodstock 94
A0002a,Woodstock 94 (Disc 1),6,Dreams,Cranberries
A0002a,Woodstock 94 (Disc 1),7,Soup,Blind Melon
A0002a,Woodstock 94 (Disc 1),8,When I Come Around,Green Day
A0002a,Woodstock 94 (Disc 1),9,Shoop,Salt-N-Pepa
A0002a,Woodstock 94 (Disc 1),10,(Stage Announcement),Woodstock 94
A0002a,Woodstock 94 (Disc 1),11,Blood Sugar Sex Magik,Red Hot Chili Peppers
A0002a,Woodstock 94 (Disc 1),12,Porno For Pyros / Porno For Pyros,Porno For Pyros
A0002a,Woodstock 94 (Disc 1),13,Those Damned Blue-Collar Tweekers,Primus
A0002a,Woodstock 94 (Disc 1),14,Headed For Destruction,Jackyl
A0002a,Woodstock 94 (Disc 1),15,Draw The Line / F.I.N.E.,Aerosmith
A0002a,Woodstock 94 (Disc 1),16,(Stage Announcement),Woodstock 94
A0002a,Woodstock 94 (Disc 1),17,Happiness In Slavery,Nine Inch Nails
A0002b,Woodstock 94 (Disc 2),1,For Whom The Bell Tolls,Metallica
A0002b,Woodstock 94 (Disc 2),2,The Hunter,Paul Rodgers Featuring Slash Jason Bonham Neil S
A0002b,Woodstock 94 (Disc 2),3,Come Together,Neville Brothers
A0002b,Woodstock 94 (Disc 2),4,Run Baby Run,Sheryl Crow
A0002b,Woodstock 94 (Disc 2),5,Deja Vu,Crosby Stills & Nash
A0002b,Woodstock 94 (Disc 2),6,Dance M.F. Dance - Kiss Off,Violent Femmes
A0002b,Woodstock 94 (Disc 2),7,Shine,Collective Soul
A0002b,Woodstock 94 (Disc 2),8,Arrow,Candlebox
A0002b,Woodstock 94 (Disc 2),9,How I Could Just Kill A Man,Cypress Hill
A0002b,Woodstock 94 (Disc 2),10,Right Here Too Much,Rollins Band
A0002b,Woodstock 94 (Disc 2),11,Highway 61,Bob Dylan
A0002b,Woodstock 94 (Disc 2),12,Pearly Queen,Traffic
A0002b,Woodstock 94 (Disc 2),13,Biko,Peter Gabriel
A0003,Essential Eighties 1,1,Call Me,Blondie
A0003,Essential Eighties 1,2,Turning Japanese,Vapours
A0003,Essential Eighties 1,3,Bette Davis Eyes,Kim Carnes
A0003,Essential Eighties 1,4,Centerfold,J. Geils Band
A0003,Essential Eighties 1,5,Always Something There To Remind Me,Naked Eyes
A0003,Essential Eighties 1,6,Power Of Love,Huey Lewis & The News
A0003,Essential Eighties 1,7,Let's Go All The Way,Sly Fox
A0003,Essential Eighties 1,8,French Kissin' In The Usa,Deborah Harry
A0003,Essential Eighties 1,9,Don't Worry Be Happy,Bobby McFerrin
A0003,Essential Eighties 1,10,Down On The Border,Little River Band
A0003,Essential Eighties 1,11,Everywhere I Go,Qed
A0003,Essential Eighties 1,12,Love At First Sight,Kim Hart
A0003,Essential Eighties 1,13,Don't Forget Me (When I'm Gone),Glass Tiger
A0003,Essential Eighties 1,14,Man Overboard,Do-Re-Mi
A0003,Essential Eighties 1,15,Cry In Shame,Jonny Diesel & The Injectors
A0003,Essential Eighties 1,16,Somethings Gotton Hold Of My Heart,Marc Almond & Gene Pitney[/code]