How to append data from .dbf files to existing access table

Question

0.00/5 (No votes)

See more:

Hi guys,

I have an access database where I have four tables that I have created by stripping data from dbf files to four catagories.Th way i do it now is this.
1. Manually import the dbf files to the database.
2. Running append query for each dbf file and appending the data to single table called "newjunodata".Then I run four macros to strip the data to tables.

I append the data by looking at the date of the last record and then append the data from that day onwards.I have to do this for each dbf file.
Can anyone please tell me how to
a) Import the dbf files to access
b) Append the needed data to the table
OR
c) Directly append the data from the dbf files to the access table at once

Thank you in advance

Posted 3-Oct-11 1:49am

Janaka Medawala

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

BHort · Answer 1 · 2011-10-03T06:06:00

Solution 1

If you link the DBF file from within Access rather than importing it you could then write your code to grab the information from the DBF file without needing to worry that it is in DBF format.

It's a bit ugly and brute force but it would work.

Oh ... please understand ... I'm thinking that you would link to a copy of the DBF that is stored in a location where the application could process the DBF to grab the updates. When you needed to re-run the application, you would simply copy the main DBF files into the location for processing ... so I wasn't suggesting linking directly to your primary DBF files that are being written to by your Clipper/xBase application.

Posted 3-Oct-11 6:06am

BHort

Updated 3-Oct-11 6:08am

v2

Comments

Janaka Medawala 5-Oct-11 0:14am

Thanks for taking your time to reply.
But the issue I need solved is much more simpler.I just want to get data from a dbf file to an access database with a vb code.with sql statements like INSERT.
I dont want to import the dbf files to access if there is a way to directly append the dbf data to access table rather than opening the dbf file in access and running an append query.
If I can just append the dbf data directly through a vb code that is what I am looking for.
Please help me if you can.
Thank you

BHort 5-Oct-11 10:20am

Well, what about using an ODBC connection to the DBF files? Using the Access ODBC driver to connect to the DBF database you should be able to again simply access the DBF file using SQL and ignore the fact that it's a DBF file. It wont be fast because you typically wouldn't have any indexes loaded but it would work.

Janaka Medawala 7-Oct-11 3:07am

Thank you so much. But I am a beginner. Can you supply me the codes