I need a small VB program to convert one client database to another. It is a very easy project for a decent coder.
(if preferred you can use VBA with excel for excel 2000)
Upon successful upload the project is done.
The two formats are from: [login to view URL] (sample attached
[login to view URL])
TO: [login to view URL] (the layout is the mdb database)
I also attached the access table for the target.
I do not care if you create a text file or do this with access (or excel) only that I can upload the result to my new platform
The output layout has to be like this;
"email","firstname","lastname","company","homephone","workphone","address1","address2","city","state","zip/postcode","country","custom1","custom2","custom3","custom4","custom5","custom6","custom7","custom8","custom9","custom10"
Each field is enclosed by a quote. Separated by a COMMA (,). Each record on a separate line.
Please be sure that no fields have commas or quotes in them - this will cause the data to be imported incorrectly.
OR
TAB delimited file
email firstname lastname company homephone workphone address1 address2 city state zip/postcode country custom1 custom2 custom3 custom4 custom5 custom6 custom7 custom8 custom9 custom10
Since many values are empty for me I think the first format has to be the one we use!
For further technical information please read this URL
<[login to view URL]>
Notes:
Command like process is ok but so many programmers already have routines that read in a file and spit out the other that I don't consider a form versus a command like a $ issue.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
## Platform
Windows, VB6 (win2000 server), excel