Aim of this sampel code is to show how to export data from a database server to excel. At this time we prefred to use mySQL. Because there are enough examples running with other databases eg. MS Access and MS SQL.
ASP has the ability to dynamically output any kind of office application format. Before to start coding, The first thing we need to do is set correct file type. Becase the browser needs to know what to do with the file. Second step is to edit file name. You can use HTML and CSS to create styles in your word document.
ASP has the ability to dynamically output virtually any type of file, provided that the correct file format is being used. The easiest type to write would obviously be text, which is what we are already doing when we output webpages. The other type, binary, is harder to do since ASP doesn't natively support binary variables. Today we will be using standard text output and the appropriate MIME file type to turn out a dynamic Microsoft Word document and a Microsoft Excel document.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.