Error Import data from SQL DB with a macro

  • Thread starter Thread starter Luisa Santos
  • Start date Start date
L

Luisa Santos

I create a Macro with TrasnferDatabase action, to import
a table from a SQL Server Database to an Access2003
database.
It returns an error: "Impossible to locate an instavel
ISAM"

But i can import the table manually.

Someone could help?
 
Hi Luisa,

Have you tested against Northwind or Pubs?

For the argument database name are you using the full Open Database
Connectivity (ODBC) connection string?

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "Luisa Santos" <[email protected]>
| Sender: "Luisa Santos" <[email protected]>
| Subject: Error Import data from SQL DB with a macro
| Date: Thu, 16 Sep 2004 09:29:52 -0700
| Lines: 12
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcScCmTMd/B6/TuzTSWLiU6EcmlLEQ==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.macros
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.macros:33323
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.macros
|
| I create a Macro with TrasnferDatabase action, to import
| a table from a SQL Server Database to an Access2003
| database.
| It returns an error: "Impossible to locate an instavel
| ISAM"
|
| But i can import the table manually.
|
| Someone could help?
|
|
|
|
 
Back
Top