ISAM error importing SQL table into Access 2003
Posted on 2006-06-30
I am trying to import SQL tables into my Access 2003 DB. I am using a macro to do this. When I run the macro, I get the error "Could not find installable ISAM" . From looking at previous ISAM questions, most were having problems in VB, not macros.
I am using the "TransferDatabase" action with type set to "ODBC Database", full path of DBF file. I have tried map drive and UNC naming.
What am I missing?
Do I need to build a Module? If so, some help on it would be appreciated. Iv'e never built one...