It seems there are no straight methods to do it. You should either alter a table, or use excel automation like:
....
objexcel.Activesheet.Saveas("foxProName.dbf",11)
....




>>>>>>>>>>>>>>your message below
Hi all,


I am trying to import an excel file into a foxpro table

myexcel.xls which has a column in date (01-FEB-2001)

When I perform following:

import from myexcel.xls xls

The date field has truncated to "02/01/20"

I has set century on

How can I import a date field from xls without truncating?

Thanks
Gan