Beware though. Don't use it without reservation. Excel is not a DB. There plenty of ways to get bit by this by relying on it for production.

geetanjaliks (1/20/2009)

---

thx for reply, but I have to use the Excel sheet bcoz the realtime data is sent only to the excel sheet and not directly to any database like...

I doubt Ent Manager can do this. Scripting in this case means "Create an SQL Statement to build the table", and that requires knowledge of a bunch of...

Hate to say it, you've got the wrong tool (Excel) for that job.

It's not designed for concurrent access like that. It has no support for transactions or isolation....

noeld (1/13/2009)

---

You are being NICE ... any table with 1000 columns...

IIRC an nvarchar(max), and the the old text type storage are 16 bytes a field. 1000 columns would roll past that row size too. Storage is 2...

Is this a text file script you are running? I've seen lots of instances (usually with application installers) where they have a template file, and they either write...

David (12/16/2008)

---

Thanks.

As I thought, this is a datetime format issue. My PeopleSoft team says that {fn CURDATE()} is the only way they can perform querys, so...

MG (12/17/2008)

---

Another method would be to use VBA in Outlook. At one point, I wrote a couple of VBA macros that examined the Subject line of mail addressed to me...

Old SQL Newbie (12/16/2008)

---

Same here. I was a nurse...

Check the SQL server and be sure you are running on the default port.

I'd be extremely wary of using MSDAORA in production. It's old, and written against Oracle 7

http://support.microsoft.com/kb/244661/

It doesn't support all the datatypes, and I can't find...

Of course, it depends. Remember that if SQL Server does any calculating, casting, joining, etc, you might force the linked server to pull the...

I assume this to simulate MySQL's ability to use originating host as part of the user identifier? It differentiates me@myhost from me@yourhost. This always struck me as an...

Sorry, there's way too many ways to look at the request. What do you want to do? Import the data in the sheets to a table? ...