Working with Text strings and pivot tables

I have a spreadsheet that reads data from a database using MS Query and the ODBC driver. The data that I am bring in contains a text string in one of the cells that represents product usage over a 12 month period. This text string is laid out in a consistent pattern of 12 block of 10 bytes for a total of 120 bytes. Because of this, the Text to column function works well to spread the data out over different columns so that I can make my pivot charts and pivot tables work. The problem I have with this, is that to make it work, I have to bring in the data in one step, and then work through the process of assigning the information to the "text to columns" in a separate step. I would like to make this easier. It would be great if I didn't have to do anything but open the file at which time the data would be updated, and the text string would be formatted and converted to separate columns, but if that is not possible I would accept a macro or similar that after pressing a button to initiate it, the macro would convert the string to columns.

Anyone have any ideas of how to simplify this process.

I will look into this but my experience with ms query is limited. You are suggesting that I change the SQL language to include the mid function right?

This is my SQL statement. Kind of messy but it works... Any help you could give with changing it would be great. I am bolding the 2 fileds that contain text strings that I would like to break up into columns.

SELECT "Inventory Master File".ITEM_NUMBER, "Inventory Master File".DESCRIPTION_1, "Inventory Master File".COMMITTED, "Inventory Master File".WAREHOUSE_MTD_USAGE, "Inventory Master File".WAREHOUSE_YTD_USAGE, "Inventory Master File".LAST_YEAR_USAGE, "Inventory Master File".USAGE1_12, "Inventory Master File".USAGE13_24, "Inventory Master File".MAJOR_PRODUCT_CODE, "Inventory Master File".MINOR_PRODUCT_CODE
FROM "Inventory Master File" "Inventory Master File"
WHERE ("Inventory Master File".ITEM_NUMBER Not Like '*%' And "Inventory Master File".ITEM_NUMBER Not Like 'CRE%' And "Inventory Master File".ITEM_NUMBER Not Like 'SPC%' And "Inventory Master File".ITEM_NUMBER Not Like 'T%') AND ("Inventory Master File".MAJOR_PRODUCT_CODE Like 'DOR%')

Great. I will give it a try and see if MS Query like the MID command.

I will get back with you later today...

Thanks again for your help, but I can't get this to work. I have tried to make the modification to the SQL in MS Query but it doesn't work. I get errors because it doens't like the commands. I brought in a guy who works with databases and if fluid in many languages including SQL and he has said the same thing. The combination of MS Query and Excel doesn't accept anything but some really basic commands so I am just going to live with what I have.

Sincerely!
Scott