Member Avatar for Aswathy

Hi,

I have a excel sheet "Biodata.xls" (already containing data).
I need to load this data to a table "Details " in sql server.

I have done it using the DTS wizard.
Is it possible to do this through some code in c#?

Can somebody help me out.......


Thanks,
Aswathy

  • 3 Contributors
  • 2 Replies
  • 254 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by blacklocist
Member Avatar for pygmalion

it can certainy be done using an ODBC, OleDB or ADO.NET connection. can you please give us a little more specifics about your excel sheet, database and connection(s)?

hope to help you out soon
pygmalion

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.