View Full Version : msoft works database to excel?
airwave
5th July 2002, 22:28
if i create data in msoft works database or msoft works spreadsheet, can this be easily converted in to excel... anyone know the anser? many thanks in advance. airwave
fobotcso
6th July 2002, 10:31
This works from Access to Excel when you export the current table of a database to an Excel spreadsheet. Don't know about Works, but maybe it's the same principle
Bre901
6th July 2002, 13:19
Don't know about the Works database.
For the spreadsheet, File/Save as... then select the appropriate Excel format (95 or 97-2000) (.xls) in the box below the filename selection box (don't know the english name of that box). Tested it on a small spreadsheet.
PaperTiger
6th July 2002, 16:15
Works does not have .xls as one of the available 'Save As' options. You would need to create an intermediate file (.csv) and then import that into Excel.
Bre901
6th July 2002, 16:52
Well I'm afraid I have to insist that I just tested that on my PC (WinMe+Works6)
PaperTiger, what version of Works have you used ?
PaperTiger
6th July 2002, 17:38
Ah yes, quite so. Didn't read the question properly:o
A Works spreadsheet can be saved as .xls, a Works database (.wdb) can't. This is for Works 4.0 on win95 (don't laugh, if it ain't broke I ain't gonna fix it).