export dbf (IV version) into access table fast method

Expand Post »

I have ic c:\mydir\mdb1.mdb with a table named tabella1 and 13 fileds named p01,p02...p13 (the table is blank without records)
In dir c:\mydir\ have a dbase1.dbf with 13 fileds.

how to recopy/export in existis tabella1 of access mdb all records from dbase1.dbf ????

Fast method, please!

I think is possible with ADO or DAO (?!)...

Similar Threads

MS Access table connection problem in Visual Basic 4 / 5 / 6
Export to dbf from ms access mdb in Python
Importing Access Table into Execl sheet in VB.NET
What is the fast method to get a site or a page indexed? in Search Engine Optimization
How to set permission to access a table on another database? in MS SQL

sal21

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

22 posts
since Feb 2008

Permalink

Sep 20th, 2009

Re: export dbf (IV version) into access table fast method

Use and insert into query (Just saw this somewhere on the web so this is from memory)

INSERT INTO TableName FROM (dBase IV; Database=PathToDBF)

(might be square brackets [])

Good Luck

vb5prgrmr

Reputation Points: 156

Solved Threads: 296

Posting Virtuoso

Offline

1,670 posts
since Mar 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Help

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: event involve in activating right mouse button click

DaniWeb Message

Cancel Changes

User Name
Password