TransferDatabase maco

  • Thread starter Thread starter JA
  • Start date Start date
J

JA

I am trying to link a table in MS SQL database to MS
Access database using the macro.
I get the error maessage " could not find installable ISAM"
Why do I get this message? I am using MS Office 2000.

Action:Transfer Database

Transfer Type:Link
Database Type:ODBC Database
Database Name:\\HQ-STT-2\WBTManager
Object Type:Table
Source:Students
Deastination:Students
Structure Only:No
 
JA,

In the Database Name argument of the macro, you need to enter the ODBC
connection string. Here is a quote from Access Help on this:
"To see an example of a connection string, link an external table to
Microsoft Access by pointing to Get External Data on the File menu and
clicking Link Tables. Open the table in Design view and view the table
properties. The text in the Description property setting is the
connection string for this table."
 
Back
Top