> 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



I am having the same problem.  I am trying to link the Excel table.  I 

have done successfully in the past and then all of a sudden I get your 

error.  My IT department successfully fixed it once before, but would not 

share the solution, now they can't find their notes and I have been down 

over a month.  I am sole user of my database, so it is not a version 

problem.  I know my company is experimenting with groups and security, but 

again no one will share exactly what is happening.  I can do my databases 

at home by creating paths the same as work, but this is becomming a pain.  

So I am also looking for an answer.  Help! please.

This is a multi-part message in MIME format.



------=_NextPart_000_003C_01C1BDC1.41AFE9B0

Content-Type: text/plain;

	charset="us-ascii"

Content-Transfer-Encoding: 7bit



Bonnie,

 

This use to happen to me quite often.  I was finally able to somewhat

pinpoint the problem to the originator of the spreadsheet (although the

problem was never resolved).  Somehow the originator was placing a

character in the spreadsheet that did not match my file import specs.  I

finally ended up importing the entire spreadsheet into a temp table.  

 

Because the spreadsheet was always in the same format (Part No, Qty,

DateOrdered), after I added the data to the temp table, I performed an

Update query from the temp table to my permanent table.  This solution

might work for you.

 

But, since you can open the spreadsheet and save it to solve the

problem, have you tried doing the same thing through automation.  Just

opening the spreadsheet, saving it, then closing it?

 

Good luck,

 



John Ruff - The Eternal Optimist J



Always looking for Contract Opportunities



 



9306 Farwest Dr SW



Lakewood, WA 98498



papparuff@c...











-----Original Message-----

From: Bonnie Preisler [mailto:bpreisler@p...]

Sent: Monday, February 25, 2002 1:47 PM

To: Access

Subject: [access] Re: 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



I am having the same problem.  I am trying to link the Excel table.  I

have done successfully in the past and then all of a sudden I get your

error.  My IT department successfully fixed it once before, but would

not

share the solution, now they can't find their notes and I have been down

over a month.  I am sole user of my database, so it is not a version

problem.  I know my company is experimenting with groups and security,

but

again no one will share exactly what is happening.  I can do my

databases

at home by creating paths the same as work, but this is becomming a

pain. 

So I am also looking for an answer.  Help! please.