How would I adjust the code so it works with SQL 2005 database?thanks for all you help,Petr
If you can use a MS access database, you should be able to map the file to a corresponding MS access database with the same name. Then, you can copy/update records to another table. You can map the MS access to a SQL server backend.