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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement