DTS import problems access 97 to SQL 7

[jurgen]

Hello,

I've a problem importing data from an access 97 database into SQL Server 7, the problem is situated on date level.

In my mdb there is a date format used day/month/year and SQL server use month day year.

How can I solve this problem, i've tried going from access to excel to sql, text file, nothing seems to do it.

Can someone give me some advice

Jurgen

 

[TomSark]

If you are having trouble with a date format, you could easily write an active-x transformation in vbscript that deals with this in your DTS package.

You could also set up a linked server to your access database and do something like this:
INSERT MYNEWTABLE
(
GoodDate
)
SELECT Convert(datetime, convert( varchar(30), wierddate ))
FROM MYACCESSDB.MYMDB..MYTABLE Tom Davis
tdavis@sark.com

http://www.sarkdallas.com