Category: Excel Macros

  • Excel Macro to Generate SQL Insert

    I am in the process of creating a database of County information, and I needed to insert several thousand records. I was able to get the data into Excel, but now I needed to write an SQL Insert statement to get the records into my database. SQL wizards, I’m sure you know a more efficient […]

  • Excel Macro Spreadsheet to HTML

    So I have a customer that needed a registration page for their E-University. This consisted of about 500 courses in various categories. I got the ~great idea to implement an AJAX Accordion to contain the categories. Within each accordion pane, I needed separate tables to house the various sub-categories. So how do I get a […]