How do I export data from Excel into an ODBC client / or plain tex

I have an excel workbook containing many sheets, of which I wish to export
the data residing on one worksheet only. I would like to know how to do 2
things.
1) export the data into an email so that it appears as flat text, not an
embedded picture, so that I am able to have a robot scrape the data to go
into an HTML ODBC. There will be approx 6 columns by 60 lines and the
workbook has many macros embedded in it.
2) export the data directly into an HTML ODBC
I am not a developer, but asking the questions for one, so appreciate layman
terms if possible, but happy to accept any and all help.
Thanks

Margaret-

May vary depending on version of Excel, but try;

1) File>Send To>Mail Recipient

2) AFAIK you cannot "export the data directly" into any type of existing
file. Use File>Save As and choose the preferred format from the Save As Type
list below File Name to create a new file of that type.

Hope this is useful, but you should check back for other replies |:>)

"Margaret" wrote:

> I have an excel workbook containing many sheets, of which I wish to export
> the data residing on one worksheet only. I would like to know how to do 2
> things.
> 1) export the data into an email so that it appears as flat text, not an
> embedded picture, so that I am able to have a robot scrape the data to go
> into an HTML ODBC. There will be approx 6 columns by 60 lines and the
> workbook has many macros embedded in it.
> 2) export the data directly into an HTML ODBC
> I am not a developer, but asking the questions for one, so appreciate layman
> terms if possible, but happy to accept any and all help.
> Thanks

Thanks CyberTaz. After reading some other older postins of questions I
pretty much saw that excel - email won't be possible in the format I was
thinking, so now I will have to follow up the ODBC Connectivity route and see
how to send limited data from a workbook to an online database.
Thanks for your reply

"CyberTaz" wrote:

> Margaret-
>
> May vary depending on version of Excel, but try;
>
> 1) File>Send To>Mail Recipient
>
> 2) AFAIK you cannot "export the data directly" into any type of existing
> file. Use File>Save As and choose the preferred format from the Save As Type
> list below File Name to create a new file of that type.
>
> Hope this is useful, but you should check back for other replies |:>)
>
> "Margaret" wrote:
>
> > I have an excel workbook containing many sheets, of which I wish to export
> > the data residing on one worksheet only. I would like to know how to do 2
> > things.
> > 1) export the data into an email so that it appears as flat text, not an
> > embedded picture, so that I am able to have a robot scrape the data to go
> > into an HTML ODBC. There will be approx 6 columns by 60 lines and the
> > workbook has many macros embedded in it.
> > 2) export the data directly into an HTML ODBC
> > I am not a developer, but asking the questions for one, so appreciate layman
> > terms if possible, but happy to accept any and all help.
> > Thanks