Look into Data Transformation Services....you can write a DTS package that will import an excel file into a table. You can execute a package from VB.NET like:

Public Function

Huh, you shouldn't have any trouble storing that in a SQL DataTime. Try appending 1/1/1900 to it before you convert it back to a Date and see what happens.

When you look at:

dr.rec_checkin_time

What value is in there before the Insert? Put a break point and a watch on it after you set it.

I don't know what dr.rec_checkin_time is, but I would guess it is a datetime field of some sort?

Try:

dr.rec_checkin_time = CDate(Now().ToShortTimeString )

You can get just the Time part of a DateTime with a ToLongTimeString or ToShortTimeString. e.g.:

Dim MyTime as DateTime

MyTime = MyDateTime.ToLongTimeString()

Then the SQL is easy...

"INSERT INTO MyTable...

Prolly something like:

SELECT * FROM MyTable WHERE (MyDate > '2006/5/8' OR (MyDate = '2006/5/8' AND MyTime >= '09:00:00')) AND (MyDate < '2006/5/10' OR (MyDate = '2006/5/10' AND MyTime <= '21:30:00'))

I'm sure there is probably...

Huh, thanks, that's cool. How do I run that script so it updates the database I want? I notice it has:

N'[dbo].

Does that just mean use the currently opened DB?

Would you post the source for the entire function or sub where you are getting the error so we can see exactly what you are doing with you SQL Command,...

Hey thanks that was more in line with what I was looking for. I appreicate the help.

Wow, that takes forever to complete....

Nevermind....strangely enough if I look in the SQL Server books online there it is.....

Haha, right until I try to mash the above into that format....

Thanks for the help though guys, I appreciate it.

Ok, talked it out with a co-worker and here is the approach I think I'm gonna go with...

select

t.a1 from thetable...

Hmmm....that is kind of an issue....I am more looking for general cooncepts than specifics. I'm trying to convert somebody's old Access into SQL and the stuff is an utter mess....

Awesome, that works. Thanks alot, I really appreciate the help.