INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: XML to Access  (Read 1019 times)

avpman

  • Galactic Citizen
  • ****
  • Posts: 441
  • Dad to three beatuiful Boxers by rescue.
XML to Access
« 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...
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 71663
  • Where did I put my teeth?
Re: XML to Access
« Reply #1 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.
Logged

Lasse_Lus

  • Citizen of the Universe
  • *****
  • Posts: 999
Re: XML to Access
« Reply #2 on: March 12, 2007, 02:46:31 pm »
copy tracks to textfile and import  :)

xml sucks  :-X  ;)
Logged
MT5FR

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42052
  • Shoes gone again!
Re: XML to Access
« Reply #3 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.
Logged
Matt Ashland, JRiver Media Center
Pages: [1]   Go Up
« previous next »