Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Need to convert a WKS file...

Thread Tools
 
Search this Thread
 
Old 19 November 2004, 10:10 AM
  #1  
GaryK
Scooby Regular
Thread Starter
 
GaryK's Avatar
 
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes on 0 Posts
Default Need to convert a WKS file...

Guys,

OK I need to open and convert a WKS file to either CSV or TXT, problem is its way greater than 65536 rows so excel chokes on it, tried various converters, no joy, cant find an ODBC driver on the web so I could then import it into MS SQL, the import in MS Access starts but then does nothing! Im running out of options now, anyone know of any utilities or apps I could use?

cheers


Gary
Old 19 November 2004, 11:34 AM
  #2  
Buckrogers
Scooby Regular
 
Buckrogers's Avatar
 
Join Date: Aug 2003
Posts: 2,644
Likes: 0
Received 0 Likes on 0 Posts
Default

Can you not split the file? So its less than 65k rows?

Or, can you not directly import to MS Access, then export to CSV?
Old 19 November 2004, 12:05 PM
  #3  
GaryK
Scooby Regular
Thread Starter
 
GaryK's Avatar
 
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes on 0 Posts
Default

Buck,

No trouble is viewing the raw format the record lengths are variable so its kinda hard to find a place to split the file, I will try that though I guess worst case I might corrupt a few records, access cannot handle it either.

Cheers

Gary
Old 19 November 2004, 03:44 PM
  #4  
Nick
Scooby Senior
 
Nick's Avatar
 
Join Date: Oct 1998
Location: Highlands
Posts: 2,805
Likes: 0
Received 1 Like on 1 Post
Default

I have Lotus 1-2-3 v9 & can load/export the file for you?
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
dpb
Non Scooby Related
14
03 October 2015 10:37 AM
ally d
ScoobyNet General
6
01 October 2015 09:22 PM
makkink
General Technical
10
01 October 2015 05:41 PM
Aaron_P85
Lighting and Other Electrical
1
28 September 2015 09:24 PM



Quick Reply: Need to convert a WKS file...



All times are GMT +1. The time now is 10:41 PM.