I need to extract data from my vBulletin SQL database in order to import into Access. It needs to do the following:
Select users of usergroup "MIGClub Member"
Output to comma delimited .CSV file in the following way:
User id number, Membership Expiry (DD/MM/YY), Username, email address, Title, Real First Name, Real Second Name, Address 1, Address 2, Address 3, Address 4, County, Postal Code, Car Model, Car Registration Mark
While this is outputted, the case of fields needs to be forced so that all use proper case (upper case first letters) except Postal code and Car registration mark which will need to be entirely upper case. Username should remain unchanged.
Also, sort by expiry date.
Interface should be such that the .CSV file can be downloaded from a link on a webpage.
The above is guide only, full accurate details will be provided when required.