backend

  1. Z

    Excel as backend database and calculation engine

    I have a complicated Excel workbook that I want to build a public website frontend for, so users can enter their inputs and have the Excel-generated results/charts display in response. Embedding the entire workbook via iframe from OneDrive-Personal or -Business/Sharepoint nearly works but it...
  2. M

    Import data from one workbook to another

    Hi Demigods, I do not have a specific issue at this time, more just want to gauge your advice... I would like to have two workbooks - one called backend, one called frontend. The backend contains rows of data. The frontend contains the backend data imported into it. Is it possible that if a...
  3. A

    Create and Verify Persistent Connection in Split DB

    Hi all! I have a database that has been split into multiple backends, and I am trying to troubleshoot and speed up a number of queries that are bogged down by joins to tables in each backend file. I have attempted to create a persistent connection using two methods: 1) I created small tables...
  4. D

    Using Access as Backend and Excel as Frontend

    I am making an inventory system for a consultant who buys products and sells them at vendor shows. I have a simple table in Access that holds the quantity of each item the consultant has. I would like to be able to use Excel as a front-end interface for manipulating this data (through...
  5. D

    Using Access as Backend and Excel as Frontend

    I am making an inventory system for a consultant who buys products and sells them at vendor shows. I have a simple table in Access that holds the quantity of each item the consultant has. I would like to be able to use Excel as a front-end interface for manipulating this data (through...

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