NancyJ
02-13-2006, 01:33 PM
I'm trying to write a utility that will basically take in a csv in one format and output it in another.
I have an online utlility that sort of does what I want to do but its not that user friendly and I would like to provide a better, offline tool to do the same job - much better to do it on their machine rather than my server ;)
So to save myself from having to look for my old VB 6 CDs, I decided to download VB Express. :eek:
I'm now completely baffled...
What I'm trying to do is:
Load in a csv file from the users computer.
Output on screen their data (in a tabular, excel kind of way)
Assign (in an easy kind of way) a column name from a list to each of their csv columns (some can be blank, their data may have more or less columns than we do)
Allow them to save those settings for next time.
Then save the only the data from the columns that match one of mine in an predetermined order (keeping my columns even if there is no match for theirs)
I'm trying to create a datafile that I can use for Load Data In File in mysql from various client csvs.
Can anyone help me out or point me in the direction of some good vbexpress tutorials. I've got about as far as creating a file->open menu and launching the file browser.
I have an online utlility that sort of does what I want to do but its not that user friendly and I would like to provide a better, offline tool to do the same job - much better to do it on their machine rather than my server ;)
So to save myself from having to look for my old VB 6 CDs, I decided to download VB Express. :eek:
I'm now completely baffled...
What I'm trying to do is:
Load in a csv file from the users computer.
Output on screen their data (in a tabular, excel kind of way)
Assign (in an easy kind of way) a column name from a list to each of their csv columns (some can be blank, their data may have more or less columns than we do)
Allow them to save those settings for next time.
Then save the only the data from the columns that match one of mine in an predetermined order (keeping my columns even if there is no match for theirs)
I'm trying to create a datafile that I can use for Load Data In File in mysql from various client csvs.
Can anyone help me out or point me in the direction of some good vbexpress tutorials. I've got about as far as creating a file->open menu and launching the file browser.