Steve has attended:
Access Introduction course
Importing data from excel
If I import data from a spreadsheet that has calculated values do I need to convert the data to value only(ie: cut - paste special - value only) in excel prior to importation or will access perform that task? And does this equally apply if the calculated data comes from separate worksheets, which won't all necessarily be imported to access.
Thanks
RE: Importing data from excel
Thank you for you question Steve. In short yes to both. Access when you use the import function Access will treat the result of the formula in the source Worksheet as the data value for the target table without your intervention.
Regards
BEST Training