Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

ms access training course london - importing data excel

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

ResolvedVersion Standard

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

Edited on Fri 20 Apr 2007, 15:07

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

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.