Solved

Xls document to mdf database upload

Posted on 2010-11-18
4
381 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

737 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