September 12, 2003

Ever get annoyed that there’s no “direct mode” environment in Perl? Instead, you have to save your code to a file and then execute it everytime. To offset this, I

You can create an ODBCDirect recordset for use with the Excel Range objects CopyFromRecordset method by using the DAO.Connection objects OpenRecordset method: Public Function CreateDaoRecordset( _ ByVal sDataSource As String,