DelphiFAQ Home Search:

SYLK: File format is not valid

 

comments1 comments. Current rating: 5 stars (1 votes). Leave comments and/ or rate it.

Question:

I am exporting data with Marathon (a SQL tool for InterBase) and get the error message 'SYLK: File format is not valid'. What is happening. And what is SYLK?

Answer:

SYLK means 'Symbolic Link Format'. Sometimes it is referred to as SLK. It was created by Microsoft Corporation before the days of Windows to store spreadsheets. The tool of choice in those early days was Multiplan which the author used on an apple ]P operating on CP/M.

This file format was used for the interchange of spreadsheet data between applications such as Multiplan and Excel. SYLK Files can also be imported directly into business graphics applications.

SYLK files are text files and attempt to be application-independent.

About the error message SYLK: File format is not valid - Excel throws this message when you open a text or CSV file and the first two characters of the file are the letters ID (uppercase). Does your database export have a column named 'ID'? Rename it in the SYLK file before you read it in Excel.

More information about this error message is here:
http://support.microsoft.com/kb/q215591/


Content-type: text/html

Comments:

2006-05-16, 23:46:57
anonymous from Australia  
rating

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: