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