Ok sorry, now I posted it in asp.net forum, I hope this helps.

Thanks

I think that this might be a way to do it?

my column in my ms sql Db that the system time has to be the same as is called tid.
So I have a suspicion that it could be done something like this:
...

Hi I have made a website where it is possible to see the days program on one page, it updates itself so it is only for that day.

But now I wan't to be able to insert a picture that changes...

Yes now it works, I just changed the column format in excel to text. :-D
Thanks alot

But is that also possible when the datatype of the column is "Varchar(50)" and it is not "datetime"

I found out that it has nothing to do with my coding. It is excel that writes: 30-12-1899 18:00:00 when I write 18:00 automatically.

So do you know anything about excel, because have tried to...

I'm sorry that I was in such a hurry. But I actually tried something else, but it didn't work.

I have 4 columns in the db. Here is hor it looks with the datatypes:

ID(bigint)
tid(varchar(50))...

ok now there is another error: Invalid column name 'dateTimeColumn'.

What is there supposed tol be in: [dateTimeColumn]?
I think that is the problem.

Now my sql statement looks like this:
SELECT CONVERT(VARCHAR(5), [dateTimeColumn], 14) * FROM PROGRAM WHERE DATE >= convert(varchar, GETDATE()) AND DATE <= DATEADD(Month, 2, GETDATE())";

the...

Ok I sent it to you

I don't think I have SQL Server Business Intelligence Development Studio I can only see microsoft sql server management studio express.

Ok but how do I then copy data from an excel document into an sql server?

Kischi

I really don't understand what you mean.
So I shouldn't use the code I have used or what?

Kischi

Hi I have a problem when I am copying data from my excel document to sql server 2005.

I have a document called database.xls
Every time I try to copy files from the document to sql server.
It...

I actually got it to work now.
I just had to change the datasource.

Thanks anyway. :-D

Kischi

Hi, I am trying to copy som data from an excel document that I have on the server into a table in my ms sql server.
I think the problem now is that I am having trouble connecting to the sql server....