How can I convert a Excel spreadsheet with formulas to Access
D Douglas J. Steele Oct 11, 2006 #2 You can't, at least not in an automated fashion. If you bring the data into a table in Access, you could create a query that has the same formulae as the spreadsheet.
You can't, at least not in an automated fashion. If you bring the data into a table in Access, you could create a query that has the same formulae as the spreadsheet.
