G
Gou
Hi,
To import a table from an SQL Server to an Access database
I use the "TransferDatabase" action. The import runs well
at the exception that there's a "sleeping" connection
remaining on the SQL server. Is there a way to terminate
this connection ?
I try to use a "Workspace" with an "OpenConnection" and
composing a "QueryDef" but then my problem is to copy the
selection of a QueryDef into an Access table without
having all the fields name from the SQL Server.
From an ODBC apprentice...
To import a table from an SQL Server to an Access database
I use the "TransferDatabase" action. The import runs well
at the exception that there's a "sleeping" connection
remaining on the SQL server. Is there a way to terminate
this connection ?
I try to use a "Workspace" with an "OpenConnection" and
composing a "QueryDef" but then my problem is to copy the
selection of a QueryDef into an Access table without
having all the fields name from the SQL Server.
From an ODBC apprentice...