Link dbf table into access database via vb6 code

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

Link dbf table into access database via vb6 code

Post by sal21 »

Link dbf table into access database via vb6 code?
how to , if is possible.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Link dbf table into access database via vb6 code

Post by HansV »

Do you know which database type it is? dBase II, IV or 5.0? FoxPro?
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

Re: Link dbf table into access database via vb6 code

Post by sal21 »

HansV wrote:
03 Nov 2022, 22:32
Do you know which database type it is? dBase II, IV or 5.0? FoxPro?
foxpro

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

Re: Link dbf table into access database via vb6 code

Post by sal21 »

hi bro before you post a solution, and save your time...
ok , i need to transfer all data record , from dbf table into a new access table.database, not a link.
sorry

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

Re: Link dbf table into access database via vb6 code

Post by sal21 »

HansV wrote:
03 Nov 2022, 22:32
Do you know which database type it is? dBase II, IV or 5.0? FoxPro?
TKS, for suggestion but solved my prob myself, with:

SQL = "SELECT * INTO TEST_DBF From [dBase IV;DATABASE=C:\Lavori_Vb6\TECNOXI\tecnoxi-002\002\].LIS_TINI"
CN.Execute SQL, , adCmdText + adExecuteNoRecords

!!!!!!!

But to speed up the new access table i need to create an index on a new table TEST_DBF , on the filed CODICE(as text string) with PERMIT DUPLICATES and on DATAT (as date) permit duplicates

User avatar
SpeakEasy
4StarLounger
Posts: 536
Joined: 27 Jun 2021, 10:46

Re: Link dbf table into access database via vb6 code

Post by SpeakEasy »

SQL ="CREATE INDEX Sal21 ON TEST_DBF (CODICE) WITH IGNORE NULL;"

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

Re: Link dbf table into access database via vb6 code

Post by sal21 »

HansV wrote:
03 Nov 2022, 22:32
Do you know which database type it is? dBase II, IV or 5.0? FoxPro?
i post have resolved, but when the dbf database is copied into access database i dont see the new table in access ide , immedtlly!
Peraphs i need to use a command similar, a refresh command?

User avatar
SpeakEasy
4StarLounger
Posts: 536
Joined: 27 Jun 2021, 10:46

Re: Link dbf table into access database via vb6 code

Post by SpeakEasy »

adExecuteNoRecords might explain that …