View Single Post
  #1  
Old June 2nd, 2008, 09:21 PM posted to microsoft.public.access
deko
external usenet poster
 
Posts: 34
Default Access 2007 - DoCmd.RunCommand acCmdImport

in Access 2003, I used "DoCmd.RunCommand acCmdImport" as part of a routine
to make importing data from Excel spreadsheets easier. After upgrading to
Access 2007 it no longer works.

Error Number 2002: You tried to perform an operation involving a function or
feature that was not installed in this version of Microsoft Access.

is there an equivalent way to programmatically open the "Get External Data"
dialog in 2007?

Thanks in advance.