Access 2002 Programming by Example

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. ...