I couldn’t find a decent way online to convert ICS files into an Excel type format for easy manipulation, or adding to documents etc. So I’ve built a simple one that is now available online: http://csv2sql.evandavey.com/ical2csv.php This takes an iCal URL and provides you with a CSV file as a download. Makes it much easier [...]
I’ve modified my CSV to SQL conversion tool (csv2sql.com) so that it now can produce both INSERT and UPDATE SQL statements from your CSV file. Previously the tool only created INSERT statements, so you could easily insert all your CSV data into your database table. However this is rather limited – what if you want to [...]
I’ve developed a simple online tool that allows you to convert a CSV file into SQL statements that can be inserted into a database table. It’s a simple process: Create a CSV file containing your data The first row of the CSV file should contain column titles which exactly match the fields in your database [...]