At 00:17 07/01/2009 -0800, Kev Noname wrote:
Specifically, I have an .mdb file (MS Access) which I have
successfully opened in Base via the .odb generated by the connection
wizard. The .odb shows me a list of tables, which I can then open
and get a spreadsheet-like interface.
Is it possible then to copy the data (easily) in the table to an
actual spreadsheet (Calc) document? That is, each row/field in the
table should be inserted into a corresponding row/column in the spreadsheet.
Yes.
o Create an empty spreadsheet document.
o Adjust the document windows so that you can see both.
o Click Tables in the Database panel at the left of the database window.
o Drag (each?) table icon from the Tables panel to a suitable cell
in the spreadsheet document.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
