Search results

  1. T

    Importing Html into Access via VBA

    I have two approaches for you, I assume you want the first one... OPTION 1 Merge all of your HTML documents into a single file and manually link that HTML document to MS Access as a linked table. You can then write queries off of that HTML table directly OPTION 2 write looping code to...
  2. T

    Export MS Access data to MS Excel and insert several blank rows above data

    thanks for the quick reply - it's appreciated. I appreciate your feedback, but am not sure how to do this with VBA. What would you recommend as the technique to add rows? I have not figured out how this would be done with DDEexecute. If you were thinking DDEexecute, would you be so...
  3. T

    Expert Advice needed please :):)

    VLOOKUP Take a look at the MS Access DLOOKUP function. I think it offers similar functionality to the MS Excel VLOOKUP function. Personally, I often write a short little ADODB search routine to provide the same kind of functionality and tie it to a click event on a form to populate a form...
  4. T

    Export MS Access data to MS Excel and insert several blank rows above data

    I want to export data from MS Access into MS Excel and make the data appear with several rows at the top. The top rows will be filled with business name, date of report generation, report title, column titles, etc. The problem is that I hve not figured out how to export MS Access data so that...
Back
Top Bottom