Does anyone have a module or sql statement that will extract the username, address, city, state, zip on a DNN 3.2 install ? 

Thank you very much in advance.

Unfortunately you can't do this through querying the database, which should be the easiest method, because the membership provider is a data jail. User data goes in via sql, but it doesn't come out! You would have to build a module to do this, but it would not be too difficult.

Another method, which would require some cleanup work in excel, would be to import the Admin User Account page into excel. In excel, under the menu Data -> import external data -> web query. Navigate to your portal, sign in as an admin, and go to the user accounts module. Click the arrow by the html table and viola, into excel. If you have a lot of users, this will be tedious though.

Well, I found a really horrible way to do it.

I went to the admin -->users and clicked to show 250 per page.  I then copied the text from the screen and pasted it into Excel.  I then cleaned it up a bit.  I sure hope my client does not want seperate columns for city, state, zip etc.

How can I be the only person that would want to do this ?  Argg.

Thanks for the help friends.