Link dbf table into access database via vb6 code?
how to , if is possible.
Link dbf table into access database via vb6 code
-
- PlatinumLounger
- Posts: 4364
- Joined: 26 Apr 2010, 17:36
-
- Administrator
- Posts: 78577
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Link dbf table into access database via vb6 code
Do you know which database type it is? dBase II, IV or 5.0? FoxPro?
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4364
- Joined: 26 Apr 2010, 17:36
-
- PlatinumLounger
- Posts: 4364
- Joined: 26 Apr 2010, 17:36
Re: Link dbf table into access database via vb6 code
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
ok , i need to transfer all data record , from dbf table into a new access table.database, not a link.
sorry
-
- PlatinumLounger
- Posts: 4364
- Joined: 26 Apr 2010, 17:36
Re: Link dbf table into access database via vb6 code
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
-
- 4StarLounger
- Posts: 563
- Joined: 27 Jun 2021, 10:46
Re: Link dbf table into access database via vb6 code
SQL ="CREATE INDEX Sal21 ON TEST_DBF (CODICE) WITH IGNORE NULL;"
-
- PlatinumLounger
- Posts: 4364
- Joined: 26 Apr 2010, 17:36
-
- 4StarLounger
- Posts: 563
- Joined: 27 Jun 2021, 10:46
Re: Link dbf table into access database via vb6 code
adExecuteNoRecords might explain that …