The VBA editor saves the macro code as a .BAS file. Use the "Export File" option on the "File" menu bar to export all of the other macro modules from the Excel workbook that you want to convert to ...

I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.

If 2K or above, ADO is the default data access library; and ADO Recordsets do sort properly.<BR><BR>Having said that, I would still prefer to use an ORDER BY clause in the SELECT statement.