Transforming .dbf to paradox .db

fisher2k4
fisher2k4 used Ask the Experts™
on
I have 3 table in dbf format that I want to transform to .db. The Tool I use is ms Access.. I import a table from dbf and then I export to .db.

First Error I have is "Index is read only" when i want to edit a register in delphi 6.

Then I read more and I found that I have to put maintened in database desktop. But I have the problem that the field index_id (primary key)(autoincrement) have no data, and when I save the keyviolate.db appear with the major of records.

What I am doing wrong? What tool i need to transform?

Structure I Have in dbf:

important.dbf (master)
  index_id(primary key)
  code(text(9))

detail.dbf (detail)
  index_id(primary Key)
  reference(text(9))
 
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2004

Commented:
use two ttables for each table you have
one of the tables you set the tabletype
to ttdbase the other to ttparadox

as databasename neter the directory where the dbase-files are, in the other the directory, where you want to have the paradox tables and supply the tablenames on both,
whereas the paradox-table must not exist

now you can use

ttableOfParadox.BatchMove(ttableOfDBase,batCopy);

meikl ;-)

Author

Commented:
Yes this is the best and easy way to do that, thanks.

But I just finished the job with another way.. when I was in MS ACCESS this **** import the field increment as number, so when I export... The Database Desktop take that as it is, as number... (keyviolate.db problem) The solution was easy in Ms Access, I changed the field "index_id" from "number" to "autoincrement" and then I export...  I run the database desktop, and now yes I can put as primary key (*)
Top Expert 2004

Commented:
well, seems you 've solved it in another way byself

you can ask at community-support
for paq this q and refund your points

meikl ;-)
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Author

Commented:
Okay thanks, How I do That?.. Sorry
Top Expert 2004

Commented:
go
http://www.experts-exchange.com/Community_Support/

post there a zero-point question, with the title
"paq q and refund points"

and in the content place the link of this q:

http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/Q_20401233.html

meikl ;-)

Author

Commented:
Thanks, Kretzchmar.
Commented:
PAQ'd and points refunded as proposed

modulo

Community Support Moderator
Experts Exchange
Top Expert 2004

Commented:
thanks, modulo ;-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial