SupportFAQXMLSpyImport/Export

Import/Export FAQ

• Is it possible to import fixed length text files?
• I am exporting an XML file to a database but only the value of the last row exported is shown in the database table. Is this a bug?
• Is it possible to export into an existing database?
• How can I easily import/export to and from Microsoft Excel?
• Why am I unable to open a newly created Access database, even though export was completed successfully?
• I am trying to connect to a database. I select "ADO connection string" and then the "Build" feature. I enter all my information and return to the Database Import screen. After I try to select a table, I get a database error regarding an invalid "username/password" or a message to the effect of "Operation is not allowed when the object is closed". Why is this?
• Why do I get the error message "Specified class not registered in registry" when attempting to connect to an Oracle database?

Import/Export FAQ Answers

• Is it possible to import fixed length text files?
  It is not possible to import fixed length text files, it is only possible to import delimited text files, i.e. where the data is separated by a tab, semicolon, space or comma.
• I am exporting an XML file to a database but only the value of the last row exported is shown in the database table. Is this a bug?
  If you have an XML file of the form:
  
  <a>
  <b> 1 </b>
  <b> 2 </b>
  <b> 3 </b>
  <b> 4 </b>
  </a>
  
  and export it to a database, only the value of the last "b" element will be shown in the "a" column of the resulting table. The only way to overcome this is to design XML files in the following manner:
  
  <a>
  <b> 1 </b>
  </a>
  <a>
  <b> 2 </b>
  </a>
  <a>
  <b> 3 </b>
  </a>
  <a>
  <b> 4 </b>
  </a>
• Is it possible to export into an existing database?
  Yes it is possible to export into an existing database. If you export into a table which is already in the database, the columns in that table must match the sub elements that are being exported into it. If you choose "create missing tables" then any of the missing tables will be created in the existing database.
• How can I easily import/export to and from Microsoft Excel?
  You can copy/paste from Excel into the Enhanced Grid View and vice versa. If you copy from Excel into the Enhanced Grid View the requirements are that you be in the Table View and have sufficient columns to paste into. You can also highlight elements and sub-elements by right-clicking them in the Enhanced Grid View and selecting "Copy as structured text". This will retain the structure of the Enhanced Grid View when pasting the copied elements into Excel.
• Why am I unable to open a newly created Access database, even though export was completed successfully?
  You are using Access 97 and XMLSpy® 2008 can only create new .mdb files for Access 2000 and later. A workaround is to create a database in Access 97 first and then export to the existing database.
• I am trying to connect to a database. I select "ADO connection string" and then the "Build" feature. I enter all my information and return to the Database Import screen. After I try to select a table, I get a database error regarding an invalid "username/password" or a message to the effect of "Operation is not allowed when the object is closed". Why is this?
  When you finish testing the connection and press ok, an ADO connection string is generated. Check if your username and password is there. The password is most likely missing. There is a check box in ADO connection string dialog, which says "Allow to save password" - you will need to check it in order to utilize this capability.
• Why do I get the error message "Specified class not registered in registry" when attempting to connect to an Oracle database?
  Please ensure that your Oracle client installation includes the component "Oracle Windows Interfaces". Without this the connection will not succeed.