ms access training course london - importing data excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

resolvedResolved · Low Priority · Version Standard

replyReply 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

For upcoming training course dates see: Pricing & availability

replyReply 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

 


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard