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