You could use SSIS and read the schema of the excel file.

http://www.mssqltips.com/tip.asp?tip=1674

Looks fairly complicated. I have't done it.

This quote looks important to note.

'You could also use a...

Thanks, I'll look at the SQL server agent options.

>>By default it should drop to the next statement when the xp_cmdshell completes. What that lead me to believe is that xp_cmdshell is NOT completing. Does it EVER finish?

No, it...

OK Sarcasm dropped. Thanks for helping.

>>1. What other statements?

Insert and updates

>>2. What is the determiner to move on?

Simply that the xp_cmdShell command was executed

<<3. Is this all in a single...

Elliott W (9/9/2009)

---

There is no way to tell, the information provided allows for no conclusions since we don't know anything about what startup.bat or the script you are talking...

http://www.sqlservercentral.com/articles/Advanced/lookuptablemadness/1464/

If you can't migrate the express installation over to Standard for some reason you can use the following to backup express. http://www.codeplex.com/ExpressMaint

Mahesh Bote (9/1/2009)

---

[font="Verdana"]There is a bit confusion between the requirement and table definitions given by you. There is not any relationship between the tables you have specified. Please post with...

Adi Cohn (9/1/2009)

---

If I understood correctly your requirement, this is one way of doing so. I did 2 joins to table #products. The first one is to get...

Lynn Pettis (8/27/2009)

---

First, I wnat to thank you for taking the time to provide everything you did in setting up your problem. It really helped a lot.

Its the least...

Import into a staging table and then insert from you staging table into your final destination.

You'll need to specify the columns in you insert from staging to destination, see BOL...

Sharepoint can create knowledge bases for this, I bet their are templates available.

What I try to encourage on ad hoc queries is paste your select into the bottom of...

Okay thanks, I wasn't aware of waitfordelay

Has anyone seen any issues with vendors saying we don't support 64 bit or is that not an issue?

Thanks all. We do use SSIS so the driver issues may be a problem. I imagine we may also have issues with 3rd party vendor support. My takeaway, If you...