I have code to do that too, and thanks by the way, it will help improve that code.

The issue, and the reason I'm usig ODBC to link to it, is Excel 2007 is NOT installed on the machine this application is running on. I thought that linking via ODBC would be more generic...

Any other ideas?
Mike


>See this message Re: Saveas: do not keep incomp. functions, do not keep chang Thread #1243150 Message #1243237 - try it.
>
>
>
>>

alter table (lcTableToFix) rename column (lcOldFldName) to (lcNewName)

>>
>>This doesn't work either, and I think I know why... (Error is syntac error)
>>
>>I downloaded the office 2007 data access pacage to give me ODBC access to excel 2007 spreadsheets.
>>
>>Modifying code create by Trevor Hancock to use the ODBC link into the spreadsheet... It creates a cursor with the results in it,
>>
>>The problem happens if the first row has an invalid fieldname i.e. a number
>>
>> (for example: The toll number - 800 number in the spreadsheet, is in the tenth column, is called 800, this is a number as the type of field[10] is numeric, I anm trying to replace the first character with an _ so that it would be a valid fieldname.
>>
>>If i issue a modify structure, I can change the name that way... but I would like to do it under my control.
>>
>>Does thi help explain the issue?
>>
>>Thanks,
>>Mike