Solved

Xls document to mdf database upload

Posted on 2010-11-18
4
379 Views
Last Modified: 2012-05-10
hey guys, i need a quick and fastest way to load xls infromation into a mdf database?

like in my xls document i have, 3 coloums

Country
PostalCode
Area

Please Help? i am a C# coder and i am using 2005 sql sever.
0
Comment
Question by:JCWEBHOST
4 Comments
 
LVL 21

Expert Comment

by:Alfred1
ID: 34170781
0
 
LVL 19

Accepted Solution

by:
Bhavesh Shah earned 500 total points
ID: 34171830
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 34171981
Hi, Want to save file as blob format or in tables.

If in blob then read file in binary stream and save to database.
or in tables then its good to use SSIS package to do.
0
 

Author Closing Comment

by:JCWEBHOST
ID: 34172056
Thanks
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now