Transfert Data from AS/400 to SQL Server via VB .Net

Hi,
   I'm trying to update the data of a table on SQL Server with the data of a table on AS/400 (both with the same structure) using VB .NET. I can fill dataSets with the data of both and merge them, I can also display the result of the merge in a data grid and everything seems fine. But still the update seems to fail because of a conversion problem between fields of Date and Time type. Is there a way to do this without using to much code since I'll probably have to repeat this with 400+ tables? Or is there a completely different way to do this transfer with or without VB .NET ?

Thanks in advance

Olivier
lussierAsked:
Who is Participating?
 
AerosSagaCommented:
There is built in functionality for such issues:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctdatevalue.asp

If you tell me the formats that you want I could work out a lil snippit for ya.

Regards,

Aeros
0
 
lussierAuthor Commented:
Ok on the AS/400 the format we have is 'YYYY-MM-DD' and on SLQ Server it seems to be 'YYYY-MM-DD 00:00:00', the date and time are in the same field. Is there a way to separate date and time in a SQL field?
0
All Courses

From novice to tech pro — start learning today.