Sailwave query -

Imported from Yahoo
1

Hi,

I would like to set up a master sailwave file with all the members at the
club and the boats they sail.

The thought of inputting the data manually, does not excite me particularly
as I have all the necessary data in an Excel spreadsheet.

Does anyone know how I can import the data into a .blw file?

Regards,

Ralph Tingle

Ogston SC

2

Ralph

Download version 3.2 build 4, and you can load data as a .csv file.

Save your spreadsheet as .csv, alter column names to fit sailwave defaults and import.

Yours

Richard Kingsnorth

Bewl Valley SC

···

----- Original Message -----

From:
ExcelRAT@cs.com

To: sailwave@yahoogroups.com

Sent: Saturday, June 02, 2001 8:35 PM

Subject: [sailwave] Sailwave query -

Hi,

I would like to set up a master sailwave file with all the members at the
club and the boats they sail.
The thought of inputting the data manually, does not excite me particularly
as I have all the necessary data in an Excel spreadsheet.
Does anyone know how I can import the data into a .blw file?

Regards,
Ralph Tingle
Ogston SC

`http://groups.yahoo.com/group/sailwave
http://www.sailwave.com/

To unsubscribe from this group, send an email to:
sailwave-unsubscribe@yahoogroups.com

`

Your use of Yahoo! Groups is subject to the [Yahoo! Terms of Service](http://docs.yahoo.com/info/terms/).

3

Hi Ralph

It can be done. I think the quickest way would be to write a macro, but I
would need to know what column had what in. The macro just creates a text
file with the data in the following format,
    "comptally","","5",""
    "compnat","","5",""
    "compfleet","","5",""
    "compboat","","5",""
    "compclass","Oppie","5",""
    "compsailno","4747","5",""
    "compcrew","David Evans","5",""
    "compclub","","5",""
    "comprating","","5",""
    "compwindrats","","5",""

I believe you have the notice of race for some 29er events coming up soon,
if you would pass them on to me I can publish them on the class website.

Thanks

Martin Mitchell

···

-----Original Message-----
From: ExcelRAT@cs.com [mailto:ExcelRAT@cs.com]
Sent: 02 June 2001 20:36
To: sailwave@yahoogroups.com
Subject: [sailwave] Sailwave query -

Hi,

I would like to set up a master sailwave file with all the members at the
club and the boats they sail.
The thought of inputting the data manually, does not excite me particularly
as I have all the necessary data in an Excel spreadsheet.
Does anyone know how I can import the data into a .blw file?

Regards,
Ralph Tingle
Ogston SC
Yahoo! Groups Sponsor

http://groups.yahoo.com/group/sailwave
http://www.sailwave.com/

To unsubscribe from this group, send an email to:
sailwave-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.