Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
|
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 12th, 2004, 08:46 AM
Registered User
 
Join Date: Jun 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to add edit records in .dbf file

Hi All,
I want to add edit records in .dbf file. Can any one send me the code or provide some link where can I get the code. I also post this Question before but no one reply to it.

By all.
Hope for the favourable reply with code.

Thanx in advance
Chandrakant
 
Old June 14th, 2004, 03:51 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Chandrakant, to edit data in a .DBF file you must open an Access database and then link to the file. Click FILE > GET EXTERNAL DATA > LINK TABLES. For "Files of Type" choose dBase III, IV, or V (depending on your data) and then pick the file from the file list. Once linked, you can write queries and perform tasks on the data just like any Access table.

After you edit, add, or delete data, you must return to your other program's data handler, e.g. DBU.EXE, and repack the data for changes to take effect.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 25th, 2004, 01:41 AM
Authorized User
 
Join Date: Jun 2004
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default

[quote GET EXTERNAL DATA > LINK TABLES. [/quote]

Yes, he is write ... you can use above way as well you may make a link of other databases files in your dbf file and then use append query to add new or edit records...

    Yes, You can do all with code too, there is no need to open Access.
    Hope it will help you too.:D

Stay Beautiyful,

Abdul Salam

There is no moving creature on Earth whose sustenance is not provided by Allah. He knows its living and its resting place,
and all that is recorded in a glorious Book. (Al-Quran)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Edit records problems Indo77 Classic ASP Databases 0 August 11th, 2005 09:35 AM
how to edit/ update records/ rows of csv file vb thePervertedMonk VB How-To 1 December 10th, 2004 02:15 PM
how to know who edit or add records? drachx General .NET 1 October 13th, 2004 05:36 AM
how to know who edit add records? drachx SQL Server 2000 9 October 13th, 2004 04:28 AM
How to add edit records in .dbf file cbpanchal VB Databases Basics 1 July 7th, 2004 11:14 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.