Group:  Microsoft Access ยป microsoft.public.access.externaldata
Thread: problems importing excel 2003 data into access 2003

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

problems importing excel 2003 data into access 2003
Dave F 28.09.2006 16:36:04
Hi,

I'm using Office 2003.

I'm trying to import a data table from an Excel workbook into an Access db.
When I navigate to the XL doc and click through the dialogue box I get an
error message:
"The wizard is unable to access information in the file [filepath]. Please
check that the file exists and is in the correct format."

The file does exist, as I can open it in Excel. And the file is a .XLS
file. Any clues here as to what this message means? I've never seen it
before. This problem is occurring at work, where I recently got a new
computer with Office 2003 installed. Previously I have been using Office
2000 and have had no problems importing data from excel sheets. So I assume
there's something about Office 2003 I don't know?

Thanks,

Dave

--
Brevity is the soul of wit.

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net