>>>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...
>>>
>>
>>So are you trying to import or export? The importing from VFP part I was doing just yesterday, (Access 2000) nothing fancy just went with the wizard:
>>- Open File menu, select Get External data
>>- Select import
>>- Select ODBC() from files of type, select DSN.
>>- Browse to your DBC or free table dir and the rest is easy.
>>
>>Make sure you have the latest version of the VFP ODBC driver. HTH
>
>I was trying both. Where can I get the latest VFP ODBC driver?
>
>My original problem was with Access 97. I could not export table with a long name (10chars) correctly.

It's at http://msdn.microsoft.com/vfoxpro/downloads/odbc.asp. The long table name thing could be a VFP ODBC driver thing.