I need to extract data from Excel forms and place the data into SQL Server tables. Some of the data is Rich-Text, some are attached pictures, while most is plain text. Any suggestions on how I can accomplish this? I assume that I'll need to use some VBA code to navigate the forms, extract the data there, and write it to SQL Server. However, I don't know how to preserve Excel text as rich text (including fonts, colors, sizes, etc.) or inserted pictures.
Any help is greatly appreciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!