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

[Guest]

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

 

[Guest]

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 |:>)

 

[Guest]

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