What I have:
- SQL Server 2008 R2 database with a table containing some columns whose values are raw HTML
- SharePoint 2007 list with standard rich text columns (not Enhanced Rich Text)
- Office 2007, Visual Studio 2008, Visual Studio 2012
What I want:
- Import the HTML from my database columns into SharePoint list columns as rich text
The fun part:
I'm not exactly a developer, and I don't have administrative rights to the SharePoint box, so I can't actually use web services. The closest I've been able to come is to use Access 2007 to write to my existing SharePoint 2007 list, but there are snags:
- Access can't seem to import HTML (or anything else) directly as rich text -- not from ODBC or from an HTML table. And once it's in as HTML, there's no feature to convert to rich text; I'd have to use VBA or something. (?)
- Excel can also import from an HTML table, but gets stuck on carriage returns -- it doesn't import correctly.
- Assuming I open my HTML table in Word, I can still only copy-paste the values within each cell, one at a time -- copy-pasting all at once reverts it all to plaintext within Access.
Besides berating me for lacking the skills to do this in a smarter way, what kind of power user-type options do I have? Is there some way I'm missing to select HTML into my Access database as rich text? This seems like an Access question, but my end goal is to get some data into SharePoint. Is there an easier way than the path I've established so far?
tl;dr:
How do I get a bunch of raw HTML from a bunch of columns in a database into a SharePoint list as rich text?
<style>
, some links, no<script>
, no images, no tables. HTML is stored in a Text column type, maximum length in my current data is 1501 characters. (Multiple Lines of Text column in SP seems to be able to support more than that, and if I understand correctly is typed the same in the SP database.) I have around 13k rows right now, but would only be looking to import a few hundred at most.