from excel

  1. P

    Get Access Table Field Names and field types into Excel

    I have created an Excel application using an Access DB. Currently it is stable, and I need to replicate and create another Access DB. I would like to be able to Import only the Fieldnames and Field Types of 3 Tables in Access. The Access Filename is "CCcalc.accdb" It resides on my Desktop. The...
  2. K

    Excel bulk data copy to SQL server using VBA / ADO

    I am fairly familiar with recordset basics and have used Excel / VBA to interface with a back-end database in the past. I have a problem where data contained in an Excel spreadsheet is taking too long to update to a SQL server due to the many rows of data (recordset.update or updatebatch is...

Some videos you may like

This Week's Hot Topics