lussier
asked on
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
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
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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