Converting Excel spreadsheet with formulae to Access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Opening excel 2010 spreadsheet from Access 4
Excel 2007 spreadsheet references older office spreadsheets 2
Link Excel to Access 3
Access will not accept a date of less than 1900 from Excel. Why 2
setting excel formula from code 4
Vlookup Error Message - Excel 2003 8
Using Spreadsheet created in Excel 2007 in Excel 2003 3

Back
Top