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?
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.