| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 78401 | 2007-04-14 01:33:00 | Copy data from Works 4.5 to Access 2003 | Scouse (83) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 540906 | 2007-04-14 01:33:00 | Hi Folks. Trying to help a friend here... database with 1300 records in Works 4.5. She wishes to upgrade, has installed, Access 2003. Has anyone any experience with transferring 4.5 data to Access? Strangely, it copies easily to Excel - but Excel is nbot what she wants. Thanks:rolleyes: | Scouse (83) | ||
| 540907 | 2007-04-14 03:09:00 | Are you able to import an Excel file into Access ? | snoopy (74) | ||
| 540908 | 2007-04-14 06:48:00 | Never used MS Works, but Snoopy's question is relevant . It is easy to import from Excel into Access . More importantly, is it a flat-file database or a relational database? Flat-file is easy - just import the data table and work from there . Relational (multi-table) needs a bit more work . You will have to import the tables separately and then set up the linkages between tables, then any queries, forms etc . Can be messy, but it is possible . I know Microsoft has its own way of perceiving reality, but I would have thought they would have provided a path from Works to Access . On the other hand . . . Hi Folks . Trying to help a friend here . . . database with 1300 records in Works 4 . 5 . She wishes to upgrade, has installed, Access 2003 . Has anyone any experience with transferring 4 . 5 data to Access? Strangely, it copies easily to Excel - but Excel is nbot what she wants . Thanks:rolleyes: |
Jayess64 (8703) | ||
| 540909 | 2007-04-14 07:38:00 | MSWorks is flat file. You can definitely import Excel into Access. |
Sweep (90) | ||
| 1 | |||||