• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: Overcoming Access Development Ob... > Bringing Together and Separating Dat...

Chapter 19. Bringing Together and Separating Data

In the last chapter, you learned how to work with data from external sources. This chapter builds on that theme by explaining what to do after you have obtained the data. It is highly likely that, at some point in your experience with Microsoft Access, you will need to obtain data from outside sources. Maybe your friend has an Excel file that he wants you to convert to Access. Or perhaps your company wants you to convert an ASCII (text) file obtained from a client’s mainframe to Access. Whatever the situation, you need to understand how to bring together (concatenate) and separate (parse) data. The reason for this is that data obtained from outside sources is not always in the proper format. To be more specific, you learn the following:

  • how to concatenate data

  • how to parse data

  • how to work through a real-world scenario in which you use concatenation and parsing to solve the problem


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint