Hi, I have an excel sheet which is inporting tables from a live website. I am using the MS SQL 2000 DTS Import/Export wizard to get the data into a database on my server. Because the excel sheet is always open to update itself every 5 minutes, SQL is returning blank tables because the file is locked..If I close the excel sheet the Query works fine. Anyone any ideas ?
Cheers
John M
Cheers
John M