Switching from Lotus to Microsoft

  • Thread starter Thread starter Louanne Michaels
  • Start date Start date
L

Louanne Michaels

I have been using Lotus as my spreadsheet and database.
Is there anyway to take all of my information and put it
into the Microsoft Excell and Access? (without manually
typing it in, of course!)

Louanne
 
Louanne Michaels said:
I have been using Lotus as my spreadsheet and database.
Is there anyway to take all of my information and put it
into the Microsoft Excell and Access? (without manually
typing it in, of course!)

Don't uninstall SmartSuite until you're sure you've completed the transition
successfully.

For database, if your 123 database files contain only single tables in
single worksheets, then you should save them as DBF files. I don't believe
Access can read any sort of 123 file (.WKS through .123). If you have .WK?
files, you could open them in Excel and save as .XLS files, which Access can
read.

As for spreadsheets, Excel only reads 123 .WK? files. It can't read .123
files produced by 123 97 Edition or Millenium Edition (R9.x). Save any .123
files in .XLS format. Many 123 @-functions won't translate into Excel, some
chart and page settings won't either. Excel 2000 and later won't run 123
classic macros, and earlier versions of Excel only support 123 Release 2.01
classic macros.
 
Don't uninstall SmartSuite until you're sure you've completed the transition
successfully.

Or ar all, if you have the spare disk space. If you suddenly come
across an old unconverted file on a floppy or a Zip disk, there's no
harm in still having the old program around.
For database, if your 123 database files contain only single tables in
single worksheets, then you should save them as DBF files. I don't believe
Access can read any sort of 123 file (.WKS through .123). If you have .WK?
files, you could open them in Excel and save as .XLS files, which Access can
read.

Both Access 97 and Access XP (2002) can read Lotus 1-2-3 files which
are in a .wk? format. (But like Excel, they won't read .123 format
files.) I'm not sure whether the Lotus filter is installed by default,
though. (You'd just need to re-run the Access setup program if it's
not. I always load all of the file filters; they don't take up much
space on a modern machine, and at least they're always there if you
need them.)
 
Back
Top