Computing.Net > Forums > Database > Add records to .dbf database thru MS Access

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Add records to .dbf database thru MS Access

Reply to Message Icon

Name: edluke
Date: May 6, 2009 at 05:21:32 Pacific
OS: Windows 98
Subcategory: DB2
Comment:

I have an old DOS program that saves data to a .dbf database file. I would now like to add data to the .dbf file through MS Access. I have successfully created a link to the table in Access and have been able to add data, however it does not show up in the DOS program. If I edit data in the table through Access the changes are reflected in the DOS program, however new additions are not. Any clue as to why?



Sponsored Link
Ads by Google

Response Number 1
Name: wizard-fred
Date: May 10, 2009 at 00:16:45 Pacific
Reply:

When you add records do you also update the index? You
can also update the index in the DOS program by running the
rebuild index function
.


0

Response Number 2
Name: Taldgaru
Date: June 24, 2009 at 07:19:51 Pacific
Reply:

What you could do is to use an ETL tool. You can have a look at Talend Open Studio as it is an ETL tool. It can perform extract, transform and load of data, but also data migration. In your case, it could be useful to operate the migration and do a daily synchronization.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More






Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links

Ads by Google


Results for: Add records to .dbf database thru MS Access

MS Access for multiple computers www.computing.net/answers/dbase/ms-access-for-multiple-computers/156.html

How to merg fields in MS Access www.computing.net/answers/dbase/how-to-merg-fields-in-ms-access/461.html

How to edit query in MS Access using batch www.computing.net/answers/dbase/how-to-edit-query-in-ms-access-using-batch/682.html