Richard, first let me thank you for courtesy silver membership. It was enough to whet my whistle and lead me to purchase a Gold membership.

My son has a landscaping business and hes using Excel to keep track of his customers.  Id like to upgrade his system to use Access but he has an extensive customer list already in Excel that I would need to import.    The problem is the spreadsheet stores customer information like Name, Telephone, Etc. in several columns, and the customers entire Property Address in one additional column.   To make it even more complex, some customers own several properties, with each additional property address in its own additional column.

Id like to store Customer information and Address information in their own tables, but I cant find any examples anywhere that shows how to make an Append query to peel out the customer info into one table, and multiple addresses from multiple columns into another single  table.   Splitting the entire address into individual Address, City, State, and Zip fields isnt a problem, Ive written a global function to do that.

Thanks,
Gary James
Brunswick, OH