Handling different character encodings when importing tabular data from CSV I’ve been fixing some minor issues with the utility in HBSMR that imports data from the Portable Antiquities Scheme. One issue was that some characters were mojibaked during the import, for example... read more Posted by Crispin Flower 24 September 2012 Categories: HBSMR MS Access VBA Comments(0)
How to drop all connections to a SQL Server database Mike S-G has passed me this useful tool for dropping all connections from a database. This is required before deleting or re-naming databases, for example. This creates a stored procedure in... read more Posted by Crispin Flower 18 September 2012 Categories: SQL Server Comments(0)