Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

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
0
lussier
Asked:
lussier
  • 2
1 Solution
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now