Script export data from MSSQL and MSACCESS to excel

[mdthanh]

Hi,

I have completed a script to export data from MSSQL or MSACCESS to Excel

Hope it useful for someone.

Screenshot:

Features:

Support database: MSSQL, MSACCESS

Export speed of MSSQL: arround 15 seconds for 700,000 records with more than 30 fields.

Will support more databases on next time and allow to select existing tables/views if any.

MDT,

ExportToExcelV1.rar

Edited October 25, 2011 by mdthanh

[ajit]

@mdthanh,

Very useful.

Really impressed with the speed. Looking forward to your next post.

Regards,

Ajit

Edited October 25, 2011 by ajit

[mdthanh]

Thanks Ajit, I am working on MySQL and support select existing tables/view of MSSQL.

Hope I can finish it soon.