>OK,
>
>1. I created table with long name tblMyVeryLongTableName in Access97.
>2. Right-Click on the table object and choose Save As/Export.
>3. To an external file.
>4. Choose ODBC database and press OK.
>5. In File Data Sorce screen choose Visual FoxPro Tables (not sharable).dsn and press OK.
>6. In Configure Connection screen select free table and specify path, for example C:\ and press OK.
>
>Close Access and open table in VFP. Should be allset at this point.
>
>HTH

Hey, Igor. These are exact steps, we tried at work. We always got 8char name (I tried couple of times by myself). I'll try at work one more time and I'm going to try it at home right now with Access 2000.

Thanks again for the help.

UPDATE Ok, I've tried with Access 2000, but I was unable to import data from VFP table. I tried different variations of ODBC, and always got some error...

>>Hi everybody,
>>
>>Yesterday we tried to export Access table into VFP table, but it always truncates the long (10char) name of the file into 8 char name.
>>
>>We're using Access 97 here, but would be able to switch to Access 2000, if it supports long names...
>>
>>Can you please tell me, if it's possible to do so from Access?
>>
>>Thanks in advance.