>Hello All,
>I've come across some unusual behavior in VFP6 and if anyone has an explanation it sure would help!
>I'm receiving excel spreadsheets that I'm changing into dbfs and cleaning them up, etc. for reporting purposes. I don't want to rename them for obvious reasons but a lot of them have dashes in their names. sheet-1 ofr instance.
>I am able to create the table sheet-1 with the command
>"CREATE TABLE sheet-1 FREE FROM ARRAY myarry"
>but when I open the data session window I find that the table
>sheet_1 is open. I cannot select sheet-1 or close sheet-1 whereas I can do both with shet_1.
>
>Why is VFP6 renaming the table alias??
>
>Thanks
>
>Sandy

In Visual FoxPro, an alias can contain up to 254 letters, digits or underscores. So, if you have something ('-' in your case) which is not part of this definition, then you take definite chances to get alias not the same as table name.