This is going onto a SQL Server Db

"Candyman" wrote:

I fianlly got the connecton. now i am trying to insert data.

What is wrong with the SQL?

INSERT INTO rpt_NewLoanMonitor SELECT * FROM [DataSource] IN 'C:\Working
Files\SQL_Scheduler.xls' 'Excel 8.0;'

It says there is a problem near the keyword IN ...

Thanks in advance
Candyman