Access 2010 on Office 2010 will not import XLS XLSX or any type of text file data. I can import from Access but not Excel or text. Registering the wizard dlls worked on older versions of Access but I dont see how that works in Access 2010
The dialog box opens but after selecting a data source, it just closes with no warning.
Office is installed on 2 computers. Both are Windows 7 - both have the same problem.
I will use Access 2003 in the meantime but this should be fixed.