Hi Souvik thanks for the help. But u know I am just a beginner in VB Script so this code is bit tough for me to decipher but I have been given a task to make an application which will convert CSV to XML. Can you please help me with something easier?
ok......as you requested i will try to create a sample program for you. but i'm telling from advance that this will take some time. so you have to wait for that.
do you have sufficient time in your hand? when should you have to submit your task?
is it your school project or some module job for a software development project?
Dim Adapter As New OleDbDataAdapter
Dim Command As New OleDbCommand
Dim xFrom As String = dtpFrom.Value.ToString.Substring(0, dtpFrom.Value.ToString.IndexOf(" "))
Dim xTo As String = dtpTo.Value.ToString.Substring(0, dtpTo.Value.ToString.IndexOf(" "))
sqlQuery = MainQuery ...