Recent content by theevilone

The last excel spreadsheet did not match the fields in the employee table at all. But I could manipulate it to do so, if need be. I am guessing by the way this customer works, the header row will not be static. Thank you.

Thank you for your help, guys. I came across a script which I am trying to get working to do this. Insert into dbo.customers (customerid,companyname,contactname) Select customerid, companyname, contactname FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel...

This doesn't really help. As I said in my thread, if someone can help me write the SQL script, I would be extremely grateful.

I have some SQL Server 2008 databases hosted on a remote server. One of the databases has an employee table with x number of fields. A customer has supplied me with an excel spreadsheet which contains a large number of number of employee details which need updating. The Excel spreadsheet...

Please help. I am new to Crystal reports and am trying to connect to a database on a SQL Server 2008 installation running locally. I created a new connection OLE DB (ADO) and then chose Microsoft OLE DB Provider for SQL Server. I get the error message below. Logon failed Details: ADO Error...

Got it working with your suggestion with 1 or 2 small changes. Thanks.

Thanks for your help anyway.

Tried that, but no luck. If you do know of any location, i would appreciate it, if you let me know. Thanks.

Thanks for the reply. In the help section, i found no reference to "out of office" at all. I found this surprising, and leads me to believe what you said that it has not been installed, when office was installed. He cant find the Office CD that should have been supplied. Either that...

No, it is a friend's PC and came pre-installed by the vendor.

Thanks for the reply, but i cannot see the Out of Office assistant under tools, as i would have expected it to appear. Any ideas why this is so.

I am using Outlook 2000. I can find no way of turning on the "out of office assistant". I would appreciate any help in doing this. Thanks in advance.

I am designing a site which will be displaying clothes. There will be a administration and a user module. Each clothes item is available in a maximum of 10 colours. The administrator has to have the ability to define the 10 colours. I have 1 table which contains all the item fields and another...

Thanks Tony. It works. Mary

Hi, I have problem inserting data into my SQL Server db using Coldfusion MX. When I insert the "£" symbol to denote GPB, in the data, the data is prefixed with a "Â". Is this a known issue. Any help or fixes would be appreciated. Thanks, Mary