Text Delimited Files

[toolsofministry]

I have a VB 6.0 Form which the user completes. Some of my clients have some of the same information in other applications databases (not all have Access). I can export their data to a text delinited file. Now the question.

How can I display beside my for and let the user drag the fields from the text delimited file to the appropriate field of my database? It would save them having to key in all the data in my application if they could.

Thanks

Jack Robinson

 

[vb5prgrmr]

First things first. I do not belive that notepad will allow interprocess drag and drop communication like wordpad or msword will, but what you could do is have the users export their data in a certain order and making blank fields if necessary for data that they do not have. Then you could write a wizard or suckup routine that parses out the text file and updates/inserts the data. I belive that this would be a lot easier to do than an inplementaion of a drag and drop routine, all you need to to is make is a standard format for the export.

Good Luck