Is it possible to be able to write a sub procedure to automatically import an Excel 2000 spreadsheet into an Access 2000 table? The location of the spreadsheet and its structure will not change and the same applies to the table? If this is possible does anyone have some useful code that i could use. Thanks.