Hi, Sandy-
It is true that if you have a table named "sheet-1" when you USE it, it's alias will be "sheet_1". So, you can do something like the following (you won't have to rename the dbf):

USE sheet-1
LOCAL lcAlias
lcAlias = Alias()
* Do some stuff
SELECT (lcAlias)
* Do some other stuff
USE IN (lcAlias)

HTH

>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