Converting .dbf file to notes database

HCL Domino Domino Forum
1

Hey,

A superior of mine has asked me to convert this file to notes if possible … Does anyone know if a .dbf from visual fox pro can transfer to a notes database.If so,how ?

Thanks,

Adam

2

Subject: RE: Converting .dbf file to notes database

Assuming you can access the .dbf file using ODBC, use LotusScript (LC LSX or LSXODBC) or LEI, to read from A and write to B. LEI is easiest but you have to buy it. It and the LC LSX (which comes with Domino) are described in LEI Redbook. The Domino Designer help contains documentation of LSXODBC (and also the LC LSX, but the redbook gives a step by step intro).

3

Subject: Converting .dbf file to notes database

If you have only one or two documents to import and if the fields are under 32 Kb, you can :

  • export your documents in text file,

  • create a new notes db with a view in which you put as much columns as your fields

  • and use file/import command (read the help file) to import your data.

Then, you should create a form with the right fields to display your datas

Hope this helps

Christian

4

Subject: Converting .dbf file to notes database

Adam,

if you need any further help with this, please contact me direct. I can also translate any Clipper / dBase type programs to Notes.

  • Robert

(Robert asrdesigns.ltd.uk)