DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

export dbf (IV version) into access table fast method

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Feb 2008

Posts: 20

Reputation: sal21 is an unknown quantity at this point

Solved Threads: 0

sal21

Offline

Newbie Poster

export dbf (IV version) into access table fast method

Sep 20th, 2009

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

•

Join Date: Mar 2009

Posts: 901

Reputation: vb5prgrmr will become famous soon enough

Solved Threads: 167

vb5prgrmr

Offline

Posting Shark

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

Sep 20th, 2009

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

If anyone has helped you solve your problem, please mark your thread as solved.

Thanks