Unable to import since install of Office SP1

[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

 

[Jeff Conrad [MSFT]]

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

 

[Mike P]

Jeff,

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

Thanks,
Mike P.

 

[Jeff Conrad [MSFT]]

Hi Mike,

Just for my own curiosity, which MSFT patch did you install?

--
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