Importing Date value in DBF From Excel (Posted by vinod kabdal) - www.foxite.com

From: vinod kabdal


	Delhi India
	vinod kabdal

Tags

Importing Date value in DBF From Excel vinod kabdal Importing Date DBF Excel

Subject:	Importing Date value in DBF From Excel
Thread ID:	190101	Message ID:	190101	# Views:	36	# Ratings:	0
Version:	Visual FoxPro 8		Category:	Windows Vista and VFP
Date:	Tuesday, August 19, 2008 12:56:41 PM

Dear all,

I am facing problem while appending data back to DBF from Excel file. The problem is that the data in Excel columnA is Charater type(14-Nov-2006) which is not appending through command line:-

CREATE CURSOR excel (date d)
APPEND FROM c:\excel TYPE xls
BROWSE
after browse no data coming to Cursor

I am attaching file for your reference.

http://www.foxite.com/uploads/bd2f45ec-15a2-4482-b707-28cd9ed9b91f.zip

Thanks
Vinod Kabdal

COMPLETE THREAD

Importing Date value in DBF From Excel Posted by vinod kabdal @ 8/19/2008 12:56:41 PM

RE: Importing Date value in DBF From Excel Posted by Yuri Rubinov @ 8/19/2008 2:36:44 PM

RE: Importing Date value in DBF From Excel Posted by vinod kabdal @ 8/19/2008 2:52:05 PM

RE: Importing Date value in DBF From Excel Posted by Yuri Rubinov @ 8/19/2008 4:22:42 PM

RE: Importing Date value in DBF From Excel Posted by Anders Altberg @ 8/19/2008 7:55:44 PM