Myrna Larson wrote:
It may be possible to import records directly from Excel into Access
with a
criterion such as the date.

You can bypass MS Access and put the data directly into the database
e.g.

INSERT INTO MyArchive ([START-DATE], [ARCHIVE-DATE], <other columns
here)
SELECT [START-DATE], [ARCHIVE-DATE], <other columns here
FROM [Excel 8.0;HDR=YES;Database=C:\MyBook.xls;].[BusinessUnit1$]
WHERE [ARCHIVE-DATE] = DATE()
UNION ALL
SELECT [START-DATE], [ARCHIVE-DATE], <other columns here
FROM [Excel 8.0;HDR=YES;Database=C:\MyBook.xls;].[BusinessUnit2$]
WHERE [ARCHIVE-DATE] = DATE()
UNION ALL
SELECT [START-DATE], [ARCHIVE-DATE], <other columns here
FROM [Excel 8.0;HDR=YES;Database=C:\MyBook.xls;].[BusinessUnit3$]
WHERE [ARCHIVE-DATE] = DATE()
UNION ALL
....
UNION ALL
SELECT [START-DATE], [ARCHIVE-DATE], <other columns here
FROM [Excel 8.0;HDR=YES;Database=C:\MyBook.xls;].[BusinessUnit8$]
WHERE [ARCHIVE-DATE] = DATE();

Perhaps the criterion required is <= DATE(), though.

Jamie.

--