Help needed to convert excel file into .DBF file

[RAMESHBABU]

Hi

Can anybody help me on the subject.

Thanks

- Ramesh Babu P

[Armando]

RAMESHBABU:

Your better alternative is Ole

Please take a look to Jeff Barnes Tips & Tricks

http://www.fivewin.info/html/tips___tri ... .php?id=46

Regards

[Enrico Maria Giordano]

Code: Select all  Expand view

#define xlDBF3 8


FUNCTION MAIN()

    LOCAL oExcel := CREATEOBJECT( "Excel.Application" )

    LOCAL oWorkBook, oSheet

    oWorkbook = oExcel:WorkBooks:Open( "E:\XHARBOUR\MYTEST.XLS" )

    oSheet = oExcel:ActiveSheet

    oSheet:SaveAs( "E:\XHARBOUR\MYTEST.DBF", xlDBF3 )

    oWorkBook:Close( .F. )

    oExcel:Quit()

    RETURN NIL

EMG

[RAMESHBABU]

Hello Mr.Enrico,

Thanks you. As usually, you have helped me this time too.

Regards,

- Ramesh Babu P

[RAMESHBABU]

Hello Mr.Enrico and Friends

When I tried to save the Excel file as .DBF file, I am getting the data column as a character type field in the
target .DBF file.

Can you please give any solution to this problem.

Thanks

- Ramesh Babu P

[anserkk]

When I tried to save the Excel file as .DBF file, I am getting the data column as a character type field in the
target .DBF file.

Dear Ramesh,

Please check whether the Data in the excel sheet is Character or not. I mean a numeric figure is entered as character in any of the rows of a particular column.

For Eg: '1234' instead of 1234 (Press F2 Key in that particular cell)

I believe that if the data in the Excel column is text type then Target .DBF is created with Character Field Type

Regards

Anser

[Detlef Hoefner]

Ramesh,

it's no good idea to save an Excel file as dbf file.
I tried this many times without success.

Excel is doing a lot of nonsense like

column types are changed from numeric to character
sometimes columns are completely ignored
the length of fields are mostly wrong
the maximum of rows to be exported is limited

It's the better way to read the cell values from Excel and write them into a dbf.

Just my 2 cents,
Detlef

[anserkk]

column types are changed from numeric to character
sometimes columns are completely ignored
the length of fields are mostly wrong
the maximum of rows to be exported is limited

It's the better way to read the cell values from Excel and write them into a dbf.

I agree with this

Regards

Anser

[RAMESHBABU]

Hi Mr.Detlef and Mr.Anser

Thanks for your attention.

Even I too faced the similar problems you have mentioned.
I too agree with your conclusion.

Thanks

- Ramesh Babu P

[hua]

it's no good idea to save an Excel file as dbf file.

Not to mention it's a feature that will be removed from future version of Excel.

[Silvio]

there is an xbrowse sample