On Thursday 19 May 2005 11:59 am, Ron Watson wrote:
> I have created a spreadsheet, saved it in the .sxc format.
> In Tools, Data Sources, New data source I have typed a name for the
> spreadsheet. Under connection I have chosen Spreadsheet and in the
> Tables Tab I am told that a url connection with this file had not
> been made. What have I not done?
> RW
There are three pieces of information needed to register a data
source (in this case, a spreadsheet): Name, Database type, and Data
source URL. You did the first two, but you did not tell OOo where your
data source (spreadsheet) was located.
There are two ways to enter the URL (location of the spreadsheet).
You can manually enter the location in the window after the
"sdbc:calc:". Or, you can click on the right on the button with
the ..... in it. This is the browse button. Use it to browse to where
the spreadsheet is located and select that it. That will enter the URL
in the window. Click OK in the Data Administration window. That should
do it.
If you have additional question, only send them to this mailing
list: [EMAIL PROTECTED] Do not personally reply to anyone answering
your questions unless the person requests you to do so.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
