asked on

DBF

Heeeeelow :)

i'm creating and connecting to DBF files

Here is my problem when i open created file colum name is interesting XCOLUMNAME_ why there is 'X' and '_'

my coneection string
Provider=MSDASQL.1;Persist Security Info=False;Data Source=dBASE Files;Initial Catalog=C:\TEMP

i thout it is ADO who dousn't understand DBF file, but when i open it with MSExcel or DateBase desktop its the same XCOLUMNAME_

thx..

calinutz

my dbf files do not look like that when I open them with Excel. The column names are ok.
What version of Fox did you use to create the dbf?

ASKER CERTIFIED SOLUTION

DynamicMonsieur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Kristao

ASKER

ADO is much better than DBE and DBE needs to have instalation pack to run it on some other computer :|.

Hey calinutz what did u wrote in connection string? and how did u made expresion to make DBF file with ADO?

this is what i wrote in adoquery

CREATE TABLE 321.DBF
(
'3' VarChar (25)
)

Wim ten Brink

> i thout it is ADO who dousn't understand DBF file, but when i open it with MSExcel or DateBase desktop its the same XCOLUMNAME_

Well, let me say something simple to you... The field is just called XCOLUMNAME_ so ask the person who created that table why he did it. He must have had some reason for it. It's not a bug.

And one more thing... Fieldnames CANNOT be numeric values! Change it to:

CREATE TABLE 321.DBF
(
'F3' VarChar (25)
)

Fieldnames cannot start with a number and neither can they be numeric... And there are a few other limitations too.

Kristao

ASKER

i'm creating that programm :P