I am working with an older database and the programmer used a data field to place a data array and parse the data in different fields. So for instance a text field with a 100 character with has information at different spaces. For instance the field is laid out like this:
Spaces 1-10: First Name
Spaces 10-20: Last name
Spaces 30-40: Address
Space 40-50: Zip Code
So I need to put information from an excel spreadsheet into this table. I would like to create a query to pull from this spreadsheet and input the data into the field in the table using the same array. What syntax would I use to create this field using exact text spaces?