Luigi-
Those look like three separate names to me. How are they similar?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
---In MS_Access_Professionals@yahoogroups.com, <no_reply@yahoogroups.com> wrote :
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
__._,_.___
Posted by: JohnV@msn.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar