Earlier, I was having problems finding an easy way of loading the data from the Nutritional Database into my hosted SQL Server. The import feature on the server was timing out with large datasets.

Rather than mucking around writing complicated regular expression switches to convert the delimited text file statements, I figured it would probably be easier to look for a tool that would export the Access version as SQL INSERT statements.

I found a couple of tools, but nothing did quite what I was looking for.  I wanted a utility that would load an access database, let me select a table, and then export the data as SQL Inserts and save them to a text file.  So, like any geek, I wrote one myself.

If you are interested, it can be installed from here:

SQL Scripter (requires .Net Framework 2.0)

It is very basic, doesn't have any features other than those listed above and it comes with no warranties... but it has suited my purpose just fine. The data has been exported from the local database and imported to the hosted one.

• martial arts