Show Bid Request Map Access into Access File Bid Request Id: 64074 Bookmark in my 'To Do' list Posted by: melyas (17 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 21.62% Buyer Security Verifications: Good Approved on: May 20, 2003 2:46:42 AM EDT Bidding Closes: May 25, 2003 2:42:08 AM EDT Viewed (by coders): 96 times Deadline: 5/27/2003 2:42:09 AM TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Windows, Database, Visual Basic, Internet Browser, Misc, Access, MS Office Enter chat room for this bid request (0 active users at Sep 8, 2003 9:00:59 PM EDT) Description: 1) Select Source Access db - Select Source table or query - If query has parameters, prompt user for them 2) Select Target Acces db - Select Target table 3) Create mapping using a interface such as this If External TextFile is true, then open then "Mapping" column will use the full path to that text file for mapping. In general I use an *.htm text file. Please note that language of the mapping. All fields from source table are in {{brackets}}. 4) Allow to save this source db, table, qury, query parameted, target db, table, and mapping for later use if needed. 5) Preview a few merged records. 6) When user accepts, Complete All merge 7) Show a progress bar of how many finished, how many to go and such. 8) Exit See attached HTML file 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: WIN 98 Visual Basic IE Must be 100% finished and received by buyer on: May 27, 2003 2:42:09 AM EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Additional Files: This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! Oleg Kreslavsky (20 ratings) in Zaporozhye, Zaporozhye Ukraine Bid id: 687,727   $45 (USD) May 20, 2003 3:50:47 AM EDT  9.5 (Excellent)     Hello, Melyas! Is you can remember I already have completed one job for you and you like it. I can help you with this project too. And I have few questions for full understanding what I must to do exactly. Generally you want to merge the table or query from source db into the target db using mapping of fieds. It's clearly, without questions... But: 1) Can you give the small example? If possible please send me the sample of the source db, target db and external text file and please tell what must contain this file? 2) In your attached file the second line has value 05752 in the Mapping column, i.e. value WITHOUT brackets. What is it? 3) What about user interface? Can you send me the screenshot of main form or tell exactly what you need to see? Thanks, Oleg.           There are 23 private replies to/from Oleg Kreslavsky. Click here to view them.