Need to fix this VB parser to parse the source excel file to result excel file and import into An Access table. I had someone work on this and is working for another file. I need you to look at the different line break an reconstruct each line. 1) 2nd row is field names 2) delete all blank rows in the excel file 3) The record is broken up mostly at column AI, or BP, sometime is broken up at both AI, and BP (look at example at [login to view URL] at row 65-67) row 67 is the ending of row 66, the combine of 67, and 66 is the ending of 65 to make up the complete line record. the text is truncated into one or multiple rows. Each row is one line part of a text memo (This suppost to be a memo field in Access) 4) Re-construct the multiple rows of text (in column one) to rebuild the text in multiple lines. (See sample in result table sheet) 5) Go thur all rows it the excel soruce tabe with the above steps. 6) Output the result into an Access table. 7) empty access table ([login to view URL]) Need this done ASAP! I prefer some that can communicate VIA Messinger, Yahoo, or MSN.
## 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) Complete ownership and distribution copyrights to all work purchased.
## Platform
pc