Need to convert a WKS file...
#1
Scooby Regular
Thread Starter
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
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
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
#3
Scooby Regular
Thread Starter
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
![Default](https://www.scoobynet.com/images/icons/icon1.gif)
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
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
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM