FYI, you all may find it worth your money to invest in Pervasive Software's Data Integrator. It's in the range of $4000-$6000 for a one machine license, but very well worth the cost. It is set up to deal with conversion of data types like that very easily. If you decide on doing something like that though talk to me - it does have it's limits as we are finding out.
Jesse > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Nicholas Leippe > Sent: Monday, August 08, 2005 7:48 PM > To: Provo Linux Users Group Mailing List > Cc: Thomas Purdy > Subject: Fulltime Job Opportunity: data import specialist > > Our company has immediate need for someone to do data import. > This is not to be confused with 'data entry'. Extra time, > if any, will be spent testing our products. > > As part of our product offering to new customers, we import > their data into our system. Some of these data sources > include ACT, Goldmine, SalesForce, Access, plain Excel and CSV files. > > Importing the data involves learning the source formats, > cleaning the data when necessary, and knowing how it > translates into our system. Candidates are not expected to > know all, nor necessarily any of these formats yet. > > > Required skills > --------------- > Basic SQL knowledge, some experience > Good at understanding data relations > > Helpful Skills > -------------- > Knowledge/experience with Excel or similar tool for manipulating data > > Not Required > ------------ > Programming knowledge/experience > > > Compensation > ------------ > Pay will begin at an hourly, entry-level rate which is DOE, > plus commissions. > > Salary + benefits may be available after a provisional period. > > > Send resumes to [EMAIL PROTECTED] > > > -- > Respectfully, > > Nicholas Leippe > Sales Team Automation, LLC > 1335 West 1650 North, Suite C > Springville, UT 84663 +1 801.853.4090 > http://www.salesteamautomation.com > .-----------------------------------. | This has been a P.L.U.G. mailing. | | Don't Fear the Penguin. | | IRC: #utah at irc.freenode.net | `-----------------------------------'