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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Excel spreadsheet with formulae to Access database
Andy,
Normally calculations (such as cells with formulas) aren't stored in tables. They're redundant, and when the data changes, then they're old. Calculations, when needed, are usually performed in the output (queries and reports). Access has many functions, similar to those of Excel. The VLOOKUP may well need to be replaced by related tables. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "AndyL82" wrote in message ... 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. |
Reply |
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 |