Solved INSERT INTO from DBF File (1 Viewer)

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:08
Joined
Oct 29, 2018
Messages
21,358
Then, try it this way:
Code:
"insert into qualifie select * from [dBASE III;HDR=NO;IMEX=2;ACCDB=YES;DATABASE=" & strPath & "].[qualifie]"
 

EzGoingKev

Registered User.
Local time
Yesterday, 21:08
Joined
Nov 8, 2019
Messages
178
Thanks that worked.

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

isladogs

MVP / VIP
Local time
Today, 01:08
Joined
Jan 14, 2017
Messages
18,186
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

Registered User.
Local time
Yesterday, 21:08
Joined
Nov 8, 2019
Messages
178
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?
 

EzGoingKev

Registered User.
Local time
Yesterday, 21:08
Joined
Nov 8, 2019
Messages
178
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

Enthusiastic Amateur
Local time
Today, 01:08
Joined
Sep 21, 2011
Messages
14,048
Create a query for just the deleted records and import that then?
 

EzGoingKev

Registered User.
Local time
Yesterday, 21:08
Joined
Nov 8, 2019
Messages
178
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

Enthusiastic Amateur
Local time
Today, 01:08
Joined
Sep 21, 2011
Messages
14,048
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.?
 

Users who are viewing this thread

Top Bottom