[AccessD] Linked Table - Excel Spreadsheet

Jim DeMarco Jdemarco at hshhp.org
Mon Aug 11 13:03:54 CDT 2003


You could try to open in Notepad and save as *.txt file, then try to open the txt in Excel (or import into Access?).  Just WAG but worth a try.

Jim DeMarco

-----Original Message-----
From: Gary Lockett [mailto:keysolns at lantic.net]
Sent: Monday, August 11, 2003 1:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Linked Table - Excel Spreadsheet


Jim

Yes I can, but I do not know how to interpret the data thereafter. There
should be about 10 columns of information, but I cannot seem to see ALL of
the data

Gary

----- Original Message -----
From: "Jim DeMarco" <Jdemarco at hshhp.org>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, August 11, 2003 2:05 PM
Subject: RE: [AccessD] Linked Table - Excel Spreadsheet


Can you open it in Notepad?

Jim DeMarco

-----Original Message-----
From: Gary Lockett [mailto:keysolns at lantic.net]
Sent: Monday, August 11, 2003 8:03 AM
To: Access Developers discussion and problem solving
Subject: 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


****************************************************************************
*******
"This electronic message is intended to be for the use only of the named
recipient, and may contain information from Hudson Health Plan (HHP) that is
confidential or privileged.  If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of the
contents of this message is strictly prohibited.  If you have received this
message in error or are not the named recipient, please notify us
immediately, either by contacting the sender at the electronic mail address
noted above or calling HHP at (914) 631-1611. If you are not the intended
recipient, please do not forward this email to anyone, and delete and
destroy all copies of this message.  Thank You".
****************************************************************************
*******

_______________________________________________
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


***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************



More information about the AccessD mailing list