I don't know what "large" means for you, and this will make a difference.

And it also makes a difference in what version of SQL Server you're on: 2005 or 2008/R2?

If...

And in re-reading your question, are you trying to import data from multiple worksheets of an Excel file into Sql Server?

If so, most of the previous post still applies. Use...

Utilize an Execute SQL Task (connected to an Excel Connection), and run a "CREATE TABLE " statement. If the xls file doesn't already exist, it will be created. It will...

Lordy... I sure hope nobody actually tries to run any of the recent code postings on this thread. While it's been fun, I think you'll really should go back and...

loki1049 (10/5/2010)

---

WayneS (10/4/2010)

---

SELECT EmployeeID,

DataYear,

YearlyWage,

FiveYearWage = (SELECT SUM(YearlyWage)...

WayneS (10/4/2010)

---

Alvin Ramard (10/1/2010)

---

Ok, time for me to put what's left of my reputation on the line. I predict that the Thread will hit 20,000 on Thursday, Oct 7th,...

This is too good not to pass on

Jim Covington (10/5/2010)

---

I need to get access to a package variable to use in the steps of my ssis package.

I have created the Variables as type String and a scope...

GilaMonster (10/5/2010)

---

And just when I thought the project I'm on couldn't get any worse..

We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting...

GilaMonster (10/5/2010)

---

This:

GilaMonster (10/4/2010)

---

For...

Lynn Pettis (10/4/2010)

---

As alluded to above in one of the posts, BEFORE dropping the database be SURE you take a FULL BACKUP of the database. This way you can...

Alvin Ramard (10/1/2010)

---

Ok, time for me to put what's left of my reputation on the line. I predict that the Thread will hit 20,000 on Thursday, Oct 7th, 2010.

...

CirquedeSQLeil (10/4/2010)

---

Alvin Ramard (10/4/2010)

---

Paul White NZ (10/4/2010)

---

jcrawf02 (10/4/2010)

---

Paul White NZ (10/2/2010)

---

Maybe, but you wouldn't have envied me and Justin carrying a sofa and six-burner BBQ up the stairs this morning....

Hmm. This made me go look at previous posts. Quite interesting...

WayneS (10/4/2010)

---

Chad Crawford (10/4/2010)

---

GilaMonster (10/4/2010)

---

Chad Crawford (10/4/2010)

---

Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just...