Conversion of database to text format.Help!!

[sasipulikkal]

I need to convert the data in database to text file and this has to be updated to database in another system.How to go about it??

[dcrake]

Can the two databases not talk to each other via linked tables? How have you got things set up at the moment?

David

[sasipulikkal]

We have a VB6 project using MS access as back end.The data has to be transferred from one system to another.We need to update the records in the second system.they have placed a text file inorder for that(we assume,we arent sure)

I will paste a text file here.Please let us know what exactly this text file is doing.and how it was created.and What type of format it is.For report,we are using crystal report.Or is the mentioned text file,a convertion of the report file.?

TEXT FILE:schedule.txt.

#^(!#LEKSHMI RAMAKRISHNAN#150#0#0#6000#0#417#~%#Sep-09#^@#
#~@)#PRINCY JOY#150#0#0#5200#100#417#~%#Sep-09#^@#
#~@!#PREETHI VISWANATH#210#8#0#7770#0#417#~%#Jul-09#^@#
#~$&#TUSHARA RAVINDRAN#250#0#0#9500#0#417#~%#Sep-09#^@#
#~)%#SANTHA C V#300#0#0#7100#0#417#~%#Sep-09#^@#
#~~@#SATHY BHASKARAN#300#0#0#10500#0#417#~%#Sep-09#^@#
#~**#BABU BHASKAR#700#0#0#23100#0#417#~%#Sep-09#^@#
#&@!#MINI REMASH#210#0#0#5880#0#417#~%#Sep-09#^@#
#&@(#USHA SURENDREN#375#0#0#10500#0#417#~%#Sep-09#^@#
#&!&#AJITHA M C#200#0#0#4000#0#417#~%#Sep-09#^@#
#&(@#DEEPA RAVINDRANATHAN#1000#0#0#20000#0#417#~%#Sep-09#^@#
#&()#VIMITHA SASI#100#0#0#2000#0#417#~%#Sep-09#^@#

[dcrake]

The text file file lloks like it has been automatically generated by some sort of proprietory system. It is using # keys as delimiters. It does not contain field headings so it is hard to decypher. Also it contains alot of key sequences. I would suggest you find out the source of the data and find out how it is being generated. And to see if you have any control of how it is being generated.

David