Importing Exacel Sheet To sql Server with Format

Question

0.00/5 (No votes)

See more:

Hi
I have Import Excel Sheet To Sql server with Full Formatting
That Is

If My Excel Sheet Contain records like Paragraph Then Grid will be show records with with Para

like

Details
-----------

Hi

This Is Para

suppose above my excel sheet contain Detail column with entry like above
Then I have to show Same entry in Grid with Same Formatting of paragraph

I have do Simple Import row By row -Not working
Bulk Insert -Not working

Try To convert Text Html Format Then Save To sql - Not Found Way

IF anyOne Knows Than Please Help

Thanks In Advance

Posted 21-Aug-11 20:33pm

dubalumesh

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

walterhevedeich · Answer 1 · 2011-08-21T21:11:00

Solution 1

Not sure what formatting you mean in your question, but to retrieve data from Excel and store it to SQL, you can either use Excel Interop[^] or Excel OLEDB[^]. Of course, to be able to insert to the DB, you need to familiarize yourself with ADO.Net.

Posted 21-Aug-11 21:11pm

walterhevedeich