Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Margaret
 
Posts: n/a
Default 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 :)
  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

Margaret-

May vary depending on version of Excel, but try;

1) FileSend ToMail Recipient

2) AFAIK you cannot "export the data directly" into any type of existing
file. Use FileSave 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 :)

  #3   Report Post  
Margaret
 
Posts: n/a
Default

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) FileSend ToMail Recipient

2) AFAIK you cannot "export the data directly" into any type of existing
file. Use FileSave 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 :)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i copy columns of data in notepad into excel? JJ Excel Discussion (Misc queries) 1 February 10th 05 10:21 PM
copying data from Excel spreadsheet to another DavidB Excel Discussion (Misc queries) 1 January 11th 05 12:26 AM
Word field codes in Excel data file Includetext mranz Excel Discussion (Misc queries) 1 December 8th 04 12:19 AM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM
stop excel from shifting cells up when a query returns no data DrLostinExcel Excel Worksheet Functions 2 November 9th 04 06:44 PM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"