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 (?!)...:-/
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.