Export data from database to other format


in this article , I will explain about how to made a small data export tool which can easily export data from database to HTML, PDF, Excel, Word, MS Access, Clipboard, XML, DBF, SQL Script, SYLK, DIF, Text and CSV.

I created a data export tool software which can easily export data from database to HTML, PDF, Excel, Word, MS Access, Clipboard, XML, DBF, SQL Script, SYLK, DIF, Text and CSV. The tool is powerful and very easy to use.

If we have a database-provider, the tool should support any database. Editing the App.config file can add other database providers. All installed providers that implement System.Data.Common.DbProviderFactory will be automatically filled in the Database-Provider list of the first step. Now, suppose we need export data from DataTable to HTML. Instead of writing tons of code, only a few steps are enough if we use this small tool.

Now, Please allow me to introduce you how to use this tool:

Step 1, Select Database
Select a Database. This tool offers ODBC, OLEDB, Oracle Client, SqlClient and Microsoft SQL Server Compact Data Provider for you to choose. Then, you need put the connection string to create a connection to the database.

Step 2, Select Data Source from your Database
This tool allows users to choose Table, View and SQL Command. Choose the file you want to export data from. Here we choose Table to export data and save as HTML.

Step 3, Select Columns
The tool will show you all columns of the selected data file. If you don't need export all of them you can only choose the columns which you need.

Step 4, Select Output File Format and Export
This tool enables you to choose output file format such as Excel, Word, PDF, HTML, MS Access, Clipboard, XML, DBF, SQL Script, SYLK, DIF, Text and CSV. And here, you also can name your output file and choose the place to save. Select HTML as the output file format.

Step 5, Open and Check Output HTML File


Tool and Source attached!
Welcome any kind of suggestions!

If you want to make one by yourself, that free DataExport component may be useful for you. You can add database unlisted and set parameters at your will.


Reference: http://stephenchy520.blog.com/2011/02/18/database-export-to-html-pdf-excel-word-ms-access-clipboard-xml-dbf-sql-script-sylk-dif-text-and-csv/


Attachments

  • dataexporttool (42333-212122-DataExportTool.zip)
  • dataexporttoolsource (42333-212122-DataExportTool_Source.zip)
  • Comments

    Author: Shawtoo07 Mar 2011 Member Level: Bronze   Points : 0

    I have downloaded the tool. It is really easy to use. Thanks.

    Author: Stephen10 Mar 2011 Member Level: Bronze   Points : 0

    My Pleasure! Welcome any kind of suggestions!

    Author: Arivazhagan Sekar29 Sep 2011 Member Level: Gold   Points : 1

    Really good, I need one more help,

    shall i get a converter which convert html to pdf?

    it must be open source and free.

    it should also support all kind of tags of html..

    Thank you.

    Guest Author: Ashok Kumar03 May 2013

    I want to make a website which can upload a excel sheet and show the data and their headings directly . Can You tell me the process?



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: