If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

I’ve heard over and over again from store owners that they need to get their customers’ names and email addresses out of their database. Now, there are many ways to do this, such as using Enterprise Manager, Web Data Administrator, MS-Access connection to their SQL server database, just plain ol’ MS-ACCESS export, and more. But what a pain to do it the technical way?!

How about just accessing the table’d data from the database using a form with a button to click to export the data? I just want the data in format I can use with Excel. The answer was a highly compatible format: Comma Separated Value format (CSV).

I looked around the web for a tool to perform this function and after playing around with many that didn’t work, I came across one that did … after a few modifications and code fixes and compatibility-fixes.

Click here to Download the Zip File.

There’s a ReadMe text file with 6 steps to get you running. Enjoy.

NOTE: Honestly it’s not a perfect solution, but considering the time to write the code from scratch, it works well without a larger time-investment.

If you want a specifically-integrated solution, contact Wallace Miller for his quick and simple export to XSL.

WALLACE’S SOLUTION vs. THIS SOLUTION

Wallace’s

Pros: Wallaces code does its thing very well: it exports customers and their email addresses and is simple to setup, plus it is integrated into SF.

Cons: It’s not free, although it costs only a nominal amount.

This Solution

Pros: Flexible to export any data out of any table from your database to CSV (readable by Excel). FREE.

Cons: Not as easy to set up and not immediatly integrated with SF.