SQL 2 Excel - Import & Export Workbooks to XML PDF Print E-mail

You can export one or more Workbooks to an XML file. The associated Worksheets will be included in the XML file automatically.

import_export_wb

This feature is NOT inteded for a complete backup of your Workbooks.

Table data is NOT included in the XML file, just the Workbook and Worksheet definition, including the SQL query etc etc. Open the XML file in a text editor and you see the included fields.


The intended use for this feature is to make it easy to

  • Export one or more Workbooks from one server and import it into another server

  • Make it easy to share reports between peers. If someone comes up with a nifty query, how to dump data for a certain Joomla extension.  Post it in the SQL 2 Excel Forum for others to download and use!

  • Export and Import works between the free and Pro version of SQL 2 Excel.
    • Extra fields used by Pro version are ignored by the Free version when importing.
    • Missing fields will be set to default when importing a XML file from SQL 2 Excel into SQL 2 Excel Pro.

 

Comments (0)add comment
feedSubscribe to this comment's feed

Write comment
You must be logged in to post a comment. Please register if you do not have an account yet.

busy
 
 
  Design by augs-burg.de & go-vista.de  
 
     
 
   
  

The Joomla!(R) name is used under a limited license from Open Source Matters in the United States and other countries. http://Joomla-R-Us.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.