Genius ! as per normal... :-) It works now...Thanks a lot
I can try to ask more:
I've to loop the query call in different databases that are in different directories but same name (both database and queries have same name)....
How can avoid to write all lines, the external query append records into a local table...
srtSQL11 = "INSERT INTO [CRM_02_new] SELECT [2_nuovi].* FROM [2_nuovi] IN '" & path2 & "'"
my database are (e.g.):
..Directory1\Subdirectory1\DB1_directory\Database1.mdb
..Directory1\Subdirectory1\DB2_directory\Database2.mdb
..Directory1\Subdirectory1\DB3_directory\Database3.mdb
My local DB is over this, and I goth the path using GetDBPath() and lowering....
Ciao
Luigi Italy
__._,_.___
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar