In the spirit of TIMTOWTDI, you could create a data set in a format that Access reads natively like dBase III. It is a bit more work but you get the added flexibility of having the output in a ubiquitous format that most programs, spreadsheets, databases, word processors and the like, can read easily. Corion has a description of the dBase header format at http://www.corion.net/cgi-bin/wiki.cgi/display/Format:DBase%20III. Once the header is built, the data is just appended sequentially with one byte added at the beginning for a deleted record flag.
in reply to Programmatically building an MS-Access DB
use strict; use warnings; use diagnostics;