Show Bid Request Import data from Excel to SQL Server Bid Request Id: 5251 Bookmark in my 'To Do' list Posted by: Mark Dennis (16 ratings) (Software buyer rating 10) Non-action Ratio: Above Average - 27.59% Buyer Security Verifications: Good Approved on: Nov 21, 2001 1:25:13 PM EDT Bidding Closes: Nov 23, 2001 1:25:53 PM EDT Viewed (by coders): 142 times 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 Enter chat room for this bid request (0 active users at Jul 11, 2003 3:10:10 AM EDT) Description: I have an Excel file with 8 individual spreadsheets in it. I imported 1 sheet into SQL Server and created a new table and that worked fine. When I use the import wizard to import the other 7 sheets, SQL Server appends the data to my database successfully. When I open the table, there is no new data though. I verified that all table and field names are spelled correctly and refreshed SQL Server, but still no data. Can someone help resolve this? Attached is Excel file. Deliverables: Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. Special Conditions / Other: ASAP as always 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! Aethyr Dragon (1 ratings) in Melkbosstrand, Western Cape South Africa Bid id: 56,368   $8 (USD) Nov 21, 2001 2:29:29 PM EDT  7 (Good)     Not a problem. I am an SQL DBA and have to do this kind of thing all the time. What result do you need? An answer to your problem or a DTS package / BCP script that you can run yourself? If you want something to run yourself, then I will need more info to set up a DTS package / Script for you - version and service pack of SQL, paths to find the files etc.