INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: avpman on March 11, 2007, 03:51:01 pm

Title: XML to Access
Post by: avpman on March 11, 2007, 03:51:01 pm

How do I get the exported XML file from MC to import properly into MS Access? I created a new DB in Acces and then used the Get External Data, selecting the MC xml file I created. But the import failes with numerous errors.

What's the EASY way to get the MC library into an Access database?

Thanks for any help...

Title: Re: XML to Access
Post by: JimH on March 11, 2007, 03:55:28 pm

Try delimited ASCII.  Or you may be able to just select what you want and drag and drop it.  Worth trying.

Title: Re: XML to Access
Post by: Lasse_Lus on March 12, 2007, 02:46:31 pm

copy tracks to textfile and import  :)

xml sucks  :-X  ;)

Title: Re: XML to Access
Post by: Matt on March 12, 2007, 09:13:28 pm

You can easily copy and paste from MC to Excel, Notepad, etc.

Excel to Access has some nice wizards, so this might help.