Show Bid Request Export data from Excell to Access via ASP Bid Request Id: 32251 Bookmark in my 'To Do' list Posted by: ContACT (15 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 5.26% Buyer Security Verifications: Excellent Approved on: Oct 23, 2002 8:26:40 PM EDT Bidding Closes: Oct 25, 2002 9:18:19 PM EDT Viewed (by coders): 261 times Deadline: 10/28/2002 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: Database, Visual Basic, ASP Enter chat room for this bid request (0 active users at Sep 23, 2003 3:23:18 PM EDT) Description: We have an existing program that exports our race data to an Excel file. We have created a web site that is used to view the races results, but runs from an Access database. We need something to get the Excel Data into the Access database automatically via a web interface. I have a perl script that can FTP from a html page to a specified directory on our server. What I would like created is an ASP script that will read a directory on our server where the excel file was FTPed to and import that data into the Access database. After the existing FTP script is run I will have this new ASP page launched. There are two distinct types of files reconisable by their file name and when FTPed will also have the date appended to the file name. The only difference between the two files is the types of races, and the outputed excel file setup is slightly different. Basically, with both tables the first few rows within the excel file (1 to 4) have the race information (Date, place, competitors, etc) this information goes into one table "Venue" to generate the race and race key. The remaining rows (6 - ???) have the records (places, prize money, name of competitor etc.) this data is to go into another table "Placings" with the race key. The access database is already set up and remains in the same directory as the Excel files will go. We are using a commercial server for our web hosting so have limited access to register DLL's, however, our existing site is already runing OK with the Access database, we just need a way to get our outputed data files into it with out re-typing. The attached ZIP file has of copy of each of the two excel files and the database. Deliverables: 1) Complete and fully-functional working program(s) in executable form as well as complete source code which is well commented of all work done. 2) Complete ownership and distribution copyrights to all work purchased. Platform: Windows NT Server Must be 100% finished and received by buyer on: Oct 28, 2002 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. Special Conditions / Other: The file is needed as soon as possible. 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! Jeffery Crooks (13 ratings) in Virginia Beach, Virginia United States Bid id: 359,399   $40 (USD) Oct 23, 2002 9:34:40 PM EDT  9.76 (Excellent)     Hello, Like to help you out. Would first like to see samples of the excel files you are using. It it's possible, .zip them up and attach them at RentACoder. I plan on using ADO to open the excel files as a data source and then import the data into your access database as you have described. I just want to make sure that the format you have your excel files in will permit this. If the excel files are workable, I can have a solution for you in a day's time. Jeffery Crooks Virginia Beach, VA           There are 3 private replies to/from Jeffery Crooks. Click here to view them.