Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

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.
0
JCWEBHOST
Asked:
JCWEBHOST
1 Solution
 
Alfred A.Commented:
0
 
Bhavesh ShahLead AnalysistCommented:
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now