On 4/6/2010 9:43 PM, Floyd Noel wrote:
Can I use an OOo spreadsheet as input to a Base query or report? If not how
can I convert an OOo spreadsheet to a Base table?
Hello FP
You can indeed create a Base file that uses a spreadsheet document as a
read-only data source.
You can use the query builder, with a limited set of functions available
compared to a standard relational database, and the reporting tools.
When you create this connected style Base file each individual sheet in
the srpeadsheet file will be represented as a table in the Base file.
For importing your spread sheet data into a Base file I would recommend
that you follow these steps:
First - create a Base file that *connects* to the spreadsheet file.
Second - create a Base file for the transfered data. So, an embedded
database file perhaps.
Third - which both Base files open, drag each table from the connected
file to the embedded database file. This will trigger the import table
wizard, you should be able to follow the prompts without any problems.
I hope that helps,
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
