Solved INSERT INTO from DBF File

[theDBguy]

VBA

Then, try it this way:

"insert into qualifie select * from [dBASE III;HDR=NO;IMEX=2;ACCDB=YES;DATABASE=" & strPath & "].[qualifie]"

 

[EzGoingKev]

Thanks that worked.

I would swear I tried that and it did not work. Maybe I typo'd it the first time.

 

[isladogs]

Just picked up this thread.
In post #1 you said you imported the DBF table(s). In post #6 you said they were linked tables. Both can't be true

 

[EzGoingKev]

Something new -

One of the DBF files contains records that are listed as deleted. When I do the import it drops these records. Is there a way to stop them from being dropped during the import?

 

[Gasman]

Undelete them?

 

[EzGoingKev]

Undelete them?

That is not an option.

The program that uses the DBF files has a "Show Deleted Records" feature. If you turn that on you can see the history of what was deleted. You can also recall something that has been deleted.

 

[Gasman]

Create a query for just the deleted records and import that then?

 

[EzGoingKev]

Create a query for just the deleted records and import that then?

Access either does not see them or ignores them.

Using the import process in the previous posts the deleted records are not imported. I linked to the table and the deleted records are still not there.

 

[Gasman]

Well as Access does not store deleted records, I think it is pretty clever of it to make note of what has been deleted and ignore those records?

I can't think of any way to get to them, unless you undelete them, and flag them in some way if you need Deleted records?

If you had done this in Access, they would be gone, full stop.?