Macro Import Table Doesn't Work

[AnnieBRNJ]

I'm using a macro to import a table and the macro connects
to the database (asks for the password) but does not import the table or give any message
I'm using the following values

Transfer Type Import
Database Type Microsoft Access
Database Name full path
Object Type Table
Source TableName
Destination TableName
Structure only No

Does it have anything to do with the way I put in the
source name. Do I need anything else but the tablename
itself?
I think it's simple but cannot find an example of what
should be in the fields

 

[dawnd3]

There is a bug that I found that causes problems with importing to Access. Try doing it manually from the file menu and then if you still have a problem, look it up at

http://www.microsoft.com

(knowledge base). I apologize I can't remember the exact article to point you to, because it has been so long, but I do remember that it was some missing .dll or something causing the import wizard to fail. (with no error message). I also remember it is an easy fix once you find the article. I hope this helps.

Dawn

http://www.calliopeconsulting.net

 

[AnnieBRNJ]

Dawn:

Thank you! I was not able to find anything on this on the
microsoft knowledge base. However, I find that if I remove
the password on the database (it is not one I created or
maintain), I can copy the table to another db. When I try to copy the table from the db without removing the password, it prompts me for the password and I enter the
correct password but nothing happens. If I remove the
password, the table is copies immediately.