linked tables to access

  1. B

    change data type of a linked table in access

    I get the below messages in access: Table is a linked table whose design can't be modified. if you want to add or remove field or change their properties or data types you must do so in the source database. I want to change the source data types, how do I do that?
  2. E

    Copy Ranges from multiple workbooks and combine into one worksheet

    hello, I'm trying to find a way to pull worksheets from different workbooks and combine them into one master worksheet. The ranges are dynamic so they will be updated ever hour or so I'd like to have a macro that, when ran, combines them into one worksheet. The workbooks are always open on...
  3. C

    Linking to Access Queries

    I have successfully been using Powerpivot to display Pivot Tables and Charts for reporting based on linked Access queries for the last six months. I change the ODBC links in my Access project to point to a different SQL database, and then simply refresh the linked queries and the reports...

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
Back
Top