Xls document to mdf database upload

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.
JCWEBHOSTAsked:
Who is Participating?
 
Bhavesh ShahConnect With a Mentor Lead AnalysistCommented:
0
 
Alfred A.Commented:
0
 
Alpesh PatelAssistant ConsultantCommented:
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
 
JCWEBHOSTAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.