If this works, I can't see why you would want to do something else. In fact, I'm going to hold on to this script, just in case.

There is a list of things called "What's New in SQL Server 2000" in the Microsoft publication "Microsoft SQL Server 2000 Introduction". If you look at the 2000 enhancements...

quote:

---

Create linked server to Excel File.

sp_addlinkedserver N'Excel', N'Jet 4.0',

...

I agree that seeing the schema will up. The logic will might be a bit complex, may have to have more than 1 temp table, but again without the schema...

We currently have 13 SQL Servers, 8 2000, 3 7.0, 2 (yes, can you believe it), still 6.5. Various production and test databases on most. I'm the only...

Our SQL Server 7.0 and 2000 machines, all running 2000 Advanced Server, seldom need a reboot. However, on the 3rd Sunday of the odd numbered months, we schedule our...

Andy Skinner and I have similar jobs. The unfortunate part with me is that it's not always SQL/Data warehousing. There's always another project or emergency that vies for...

For me, it was by accident. I started in the early 80's with the PICK environment (does anybody remember it?) with BASIC and the 4GL called ENGLISH which is...