Betreft: Re: [AccessD] Linked Table - Excel Spreadsheet

marcel.vreuls at achmea.nl marcel.vreuls at achmea.nl
Mon Aug 11 07:06:14 CDT 2003


Gary,

I had a similar problem. I had the spreadsheet also open in excel and that
causes the message Unable to read the file.

G.r marcel




"Gary Lockett" <keysolns at lantic.net>@databaseadvisors.com op 11-08-2003
14:02:59

Antwoord aub aan Access Developers discussion and problem solving
      <accessd at databaseadvisors.com>

Verzonden door:     accessd-bounces at databaseadvisors.com


Aan:  "Access Developers discussion and problem solving"
      <accessd at databaseadvisors.com>
cc:

Onderwerp:     Re: [AccessD] Linked Table - Excel Spreadsheet


Having reread my post, it is rather misleading. When I try opening the
spreadsheet with Excel, I am unable to open the file. It says "Unable to
read file".

----- Original Message -----
From: "Gary Lockett" <keysolns at lantic.net>
To: <AccessD at databaseadvisors.com>
Sent: Monday, August 11, 2003 1:51 PM
Subject: [AccessD] Linked Table - Excel Spreadsheet


I have a customer who has a database with a table linking to an Excel
Spreadsheet. This morning (Monday morning blues) they are unable to access
the data. Access gives an error message saying that the external table is
not in the correct format. When I tried opening the spreadsheet with Excel,
the file is not in the correct format.

The customer says that the only problem they have had is running out of
space on the C: Drive - could this corrupt the Excel file?

Are there any utilities available to repair an Excel file? What steps do I
need to take to retrieve the data?

The customer promises to start taking backups from now on. I need to
recover
their data. Can someone on this wonderful list help make me look good in
the
customers eyes????

Gary Lockett
Key Solutions
Port Elizabeth
South Africa



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


************************************************************
Scanned by @lantic IS Virus Control Service
This message was scanned for viruses and dangerous content.
@lantic Internet Services (Pty) Ltd. - http://www.lantic.net
eScan for Windows-based PCs - http://www.escan.co.za
************************************************************


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





********************* DISCLAIMER *********************
De informatie in dit e-mail bericht is uitsluitend
bestemd voor de geadresseerde. Verstrekking aan
en gebruik door anderen is niet toegestaan.
Door de electronische verzending van het bericht
kunnen er geen rechten worden ontleend aan de
informatie.
************************************************************



More information about the AccessD mailing list