Unable to import since install of Office SP1

  • Thread starter Thread starter Mike P
  • Start date Start date
M

Mike P

I am unable to import Excel, CSV, or Text files into Access from External
Data -> Import tabs since I have installed Office 2007 SP1. The error I get
during import is –

|9 can’t file the field “|†referred to in your expression.
You might have misspelled the field name or the field may have been renamed
or deleted.

HELP – I have spend hours working with this until I figured out the problem.
I have one computer that I did not install SP1 on and the import works
fine. Every other computer with SP1 does not.

I tried to uninstall SP1, but the computer says it is uninstall able. I do
at east one import a week from a 5000+ row excel spreadsheet. Any ideas or
help is greatly appreciated.

Thank You,
Mike P
 
Mike,

During the Import Wizard are you selecting the check box "First Row Contains
Column Headings"?

Just to clarify, if you take the *exact same* Excel file it imports fine on
Access 2007 RTM, but not with Access 2007 SP1.
Correct?

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
Jeff,

That is correct. I installed another security patch from MSFT this morning
and now the import is working fine.

Thanks,
Mike P.
 
Back
Top