How to edit DBF file in Excel 2003 ?

[Sultix]

Hello

i have this huge problem, i cannot seem to get it work.

I have an existing dbf file, which needs to be added few hundred new rows to make importable to lotus organizer.

Whenever i add new rows to DBF file.. After saving the file in Excel, it shows nothing.. as being the new rows was never been added..

Can anyone help me please to fix this problem?

How can i edit a dbf file in Excel 2003?

macros? addons ? addin?? software? anything please.. just please not shareware stuff.

Greetings
Sultix

 

[SteveO59L]

As far as i can remember, there is a limit on the number of rows that Excel will import from a dbf file. If you have exceeded this limit (I cant remember how many records it is) then your data wont be imported to Excel

 

[Sultix]

As far as i can remember, there is a limit on the number of rows that Excel will import from a dbf file. If you have exceeded this limit (I cant remember how many records it is) then your data wont be imported to Excel

well to be honest.. the dbf file i have has only 5 rows..- exported for testing purpose.
i wanted to add 200 rows.

columns, data etc all ready to be pasted.

and beside i am not trying to export or import from dbf. i am trying to edit dbf.

 

[ebey]

Hi
I am facing a problem with Excel 2003.

I have an existing dbf file, which needs to be added a few hundred new rows to which I am having in another Excel sheet

Whenever i add new rows to DBF file.. After saving the file in Excel, it shows nothing.. as being the new rows was never been added..


But I am able to edit the existing data, it is saving.

Can anyone help me please to fix this problem?

How can i edit a dbf file in Excel 2003?