It didn't worked...but I've just find out how to do it: Insert Into Results.dbf Values (CtoD([06/18/2005])) Only by this way it worked. Thx for everybody's help :laugh:

Just only ASCII text?? So why is there a Date format for .dbf file...??? I tried to insert '20070922', "20070922" and this didn't work as well... :(

Hi!! I'm having a problem( again) while creating a .dbf file. First, I have this line to create the table: Create Table Results.dbf (BuyDate Date) And this worked well. Now, I've this line to add a date in the table: Insert Into Results.dbf (20070922) But it gives me a "Data type mismacth" error. I've already saw that the date format is YYYYMMDD. So where is the error here?? :confused:

Hi There!!! Thank You, perryf_00. That worked well. :-D Now I've to modify that Column names to 10 chars max.

Hi!!! I'm creating a program to build a DataTable and I want to export it to a .dbf file. One of the result is this line: Create Table Results.dbf ( NumerodeIndividuosouNinhos number(4,0), Quadricula Char(5)) Unfortunely, it gave me a OleBdException and the error was "Field name is a duplicate or invalid.". But where is the error here? It isn't a duplicate field...if it's invalid, why is invalid? Thank You