> I have a client that has a large membership database (4000+ members) > in Access, but the website we are building uses a mysql database. They > would like to upload their membership information periodically (monthly, > weekly, maybe even daily). I am guessing that they could/should export > the file as a CSV - and then they could upload and import that - - but I > don't even know where to begin. (I think I may also be asked to export > the data back from the website as well.)
I am reminded of an old site that I worked on where the client had a very similar request, except that their poison of choice was Excel. The solution that we had was to build a form that allowed the user to upload their excel file into their web path. If there was a previous version of the file, it was renamed to indicate when it was replaced. We had a DSN pointing to the Excel file and once the upload was completed, the user clicked on a button that fired off a page to execute the "import process" (a sequence of SQL statements). The user also had the ability to download the Excel file via a page that looked for all of the .xls files using CFDirectory and linking to them. In your case you may be able to implement a similar strategy. Granted, what I had going on involved SEVERAL sheets in the Excel workbook. It would have translated to 15 different CSV files. Hope this helps! Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3090 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
