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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top