General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>hey everyone,
>
>i am trying to append a date field from an xls sheet to a date field in a foxpro table using the append function.
>
>the problem is that the date fields in the fox pro table do not populate. Does anyone know how to get the date fields to append correctly?
>
>the code i am using looks like:
>
>use table
>
>append from xls;
>fields field1, ;
> date field, ;
I'm not familiar with this syntax for APPEND FROM. The "date field" bit. So far as I know you just list fields, not the type. But, that said...if you have control over the Excel file, I've found that if you format the Excel date column as date format 03/14/1998 (with the year) then the append pulls the date in okay. Any other format, such as "3/14/98" doesn't work. (It yields a blank date in the fox table.)
If you _don't_ have control over the Excel file, you may need to resort to OLE automation.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only