|
 |
access thread: Error Message: External table isn't in the expected format.
Message #1 by donald.dalessandro@b... on Mon, 18 Jun 2001 14:00:15
|
|
Hi all,
I'm getting an error message when trying to import a Microsoft Excel
spreadsheet into Access 97. The error message reported by Access 97 just
after I try to import is as follows: External table isn't in the expected
format.
The spreadsheet (.xls) I'm trying to import is being sent to me daily and
it is the same story every day. I found one remedy that doesn't help me
with automation. If I open the spreadsheet with Excel and simply save it
and try importing again, all works well without a glitch. Does anyone
have ideas?
Thanks,
Don
Message #2 by Miriam Engelberg <MiriamE@c...> on Mon, 18 Jun 2001 09:44:47 -0700
|
|
My guess is that the person sending it to you is using either Excel 2000 or
an older version of Excel. Then when you save it in your version, the
database can read it because it is now compatible.
Miriam Engelberg
Technology Faculty/Chief Cartoonist
CompassPoint Nonprofit Services
www.compasspoint.org
(xxx) xxx-xxxx
-----Original Message-----
From: donald.dalessandro@b... [mailto:donald.dalessandro@b...]
Sent: Monday, June 18, 2001 7:00 AM
To: Access
Subject: [access] Error Message: External table isn't in the expected
format.
Hi all,
I'm getting an error message when trying to import a Microsoft Excel
spreadsheet into Access 97. The error message reported by Access 97 just
after I try to import is as follows: External table isn't in the expected
format.
The spreadsheet (.xls) I'm trying to import is being sent to me daily and
it is the same story every day. I found one remedy that doesn't help me
with automation. If I open the spreadsheet with Excel and simply save it
and try importing again, all works well without a glitch. Does anyone
have ideas?
Thanks,
Don
Message #3 by "Johnny The Saint" <jts_2k@h...> on Mon, 18 Jun 2001 17:08:27 -0000
|
|
Why don't you import the spreadsheet as a text file, I had the same problem
and changed it to import a text file... It seems to work at the minute and
have been using this way for a couple of weeks now...
----Original Message Follows----
From: donald.dalessandro@b...
Reply-To: "Access" <access@p...>
To: "Access" <access@p...>
Subject: [access] Error Message: External table isn't in the expected
format.
Date: Mon, 18 Jun 2001 14:00:15
Hi all,
I'm getting an error message when trying to import a Microsoft Excel
spreadsheet into Access 97. The error message reported by Access 97 just
after I try to import is as follows: External table isn't in the expected
format.
The spreadsheet (.xls) I'm trying to import is being sent to me daily and
it is the same story every day. I found one remedy that doesn't help me
with automation. If I open the spreadsheet with Excel and simply save it
and try importing again, all works well without a glitch. Does anyone
have ideas?
Thanks,
Don
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
|
|
|
View Cart
