98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access training course london - Importing data from excel
ms access training course london - Importing data from excel
Resolved · Low Priority · Version Standard
Fri 20 Apr 2007, 11:32Delegate Steve said...
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
Fri 20 Apr 2007, 15:06
Edited on Fri 20 Apr 2007, 15:07Trainer Tom said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Related tablesWhen you have related tables such as Customers and their Orders, the Customer table is the Primary table. |
