| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Excel spreadsheet with formulae to Access database
We currently use an Excel spreadsheet at work which includes a number of
VLOOKUP and SUM formulae. I'd like to create a Microsoft Access database from this spreadsheet - is there a way of retaining or replicating these formulae in Access? (I do not want to simply link the spreadsheet to Access as this won't speed up access to the data) Thanks, Andy -- Andreas L. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I extracts datas from Access database to Excel? | Excel Discussion (Misc queries) | |||
| Finding and killing all Access queries in an Excel spreadsheet | Links and Linking in Excel | |||
| Excel as Data Entry into Access Database | Excel Discussion (Misc queries) | |||
| Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) | |||
| Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions | |||
Threaded Mode
