954,551 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

export dbf (IV version) into access table fast method

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 (?!)...:-/

sal21
Newbie Poster
22 posts since Feb 2008
Reputation Points: 10
Solved Threads: 0
 

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
Posting Virtuoso
1,912 posts since Mar 2009
Reputation Points: 156
Solved Threads: 296
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You