>This seems complex but am looking for ideas. I want to dump a daily vfp table that produces 1 column of data with x number of rows.
>I want to import/append this 1 column into excel in the next available blank column. so each day the available blank column progresses such as A,B,C.....AA,BB,CC etc.

You have plenty of choices. You can open Excel file in VFP using VB-automation, check for next empty column and fill it. Another way would be importing excel file to foxpro table, adding new field (ALTER TABLE), filling it (UPDATE_SQL) and exporting back to excel.