View Single Post
Old 12-30-07, 04:27 PM   #1
technoid
Registered User
 
Join Date: Jul 2004
Location: Denton, Texas
Posts: 505
Default MySQL Export to XLS using Classic ASP

I wrote an export function to create a CSV file but it would be nice to be able to create a Real XLS file too. I've looked around a lot but haven't found any good example code to do it. I'm using Classic ASP so if you know where I can get something to help me I'd appreciate the information.

I'm running MySQL on a Windows 2000 Server at work using Classic ASP to write the webpages with. I'd use something better if I knew how

I installed PHP on my home system running XP Pro and IIS and could install PHP at work too if necessary to get the XLS working. I did find some PHP sample code to create a real XLS file but it's very bare bones and you can't do any formatting. But it does seem to create a real XLS file since Excel will open it without complaining and it's in a binary format. I could use that or port it over to ASP but since it's so bare bones a CSV file seems as good.

I guess I could ask another question too. At work on the Windows 2000 Server I have a SATA RAID using an Adaptec 1200A and anytime I try to put the MySQL data directory on the RAID Array it takes down the RAID after about 45 minutes of just sitting there looking like it's looked up. So I have the MySQL data directory on the OS drive, not a good solution. If anyone has any information about that problem I'd love to hear that too.

Thanks for any help.
__________________
Antec-SOLO | ASUS-P5Q-SE | C2D-E8600 | AC-Freezer-7-Pro | Seasonic-S12-550W | 3GB-KVR-PC2-6400 | GTX-560Ti | SB-XtremeGamer | Pioneer-BDR-205 | Samsung-S223B | Dell-U2412M
technoid is offline   Reply With Quote