OfficeExporter - SQL or DataTable to xls and mdb

WHAT IS OfficeExporter

OfficeExporter exports information from a SQL Server, ODBC Data Source or DataTable to both an Excel document or an Get Admission To Database without the desire of having Place Of Job installed.

Integrate OfficeExporter in your venture

Just add the project on your solution and start the use of the library like within the examples. Create a OfficeWriter item, create a desk and write your knowledge to Excel or Get Admission To.

WHAT IS integrated

• full supply code
• instance files
• instance challenge
• heavy commented instance and library (public strategies)

Necessities

I Recommend to have the Microsoft Access Database Engine put in, it's want to write Excel and Get Entry To files. Its included in newer versions of Microsoft Place Of Job. There Is no need to have Administrative Center installed despite the fact that, just the Get Entry To Database Engine.

Contact me

if you happen to have any questions or need assistance, feel free to contact me.

Changelog

• 1.0 (2015-02-15)
• initial release
• 1.1 (2015-05-19)
• brought the capability to export information from databases (Odbc information resources and Microsoft Sql Server) too
• code clean up
• renamed mission to OfficeExport, didn’t like the “Easy” section anymore, it’s still easy to make use of though :>
• all write functions now take now the desk title where the information should be imported in
• all knowledge table and unmarried row write functions now take the columns as additional parameter to import the values properly
• brought a “WriteSingleRow” method to insert unmarried rows right into a Excel or Get Entry To table

FULL DOWNLOAD