p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

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.




  Return to Index