Adventure Works on Access

Adventure Works on Access - this was an exercise for one of my periods between contracts. The SQL Server 2008 Adventure Works database was loaded into an Access 2010 database. The most time consuming part after the actual load of the data was writing a VBA routine to read a tab delimited text file into an Access table.

The supporting functions are here, a simple substitute for BULK INSERT when the delimiter is more than one character, in this case plus and bar +| ... along with a test to detect whether a table exists, and wrapper functions for the built in conversion functions CLng, CDBL and CDate to deal with missing/Null values.

Here is the code to do the create and load.