roxannep
Technical User
- Jun 20, 2000
- 69
I've tried a variety of scenarios and exports to get this to happen with no luck. Perhaps someone has a method that would work!
I need to export the results of a query into an Excel Spreadsheet (which is forwarded to an auction site .... they are requiring .xls format).
Problem: in order for the information to appear correctly once it is loaded to the auction site (html), it needs to include some html code around some of the fields but not all ...
Example:
Each of these would be in their own columns:
[title]
<html code> [description] <more code>
<more code> [image1]
<more code> [image2]
[duration]
[min-bid]
A secondary hitch is that the data entry people have to be able to change that html code occassionally when the owner wants a different color or font used or has a new paragraph of information that must be included with every record uploaded.
The code around the [description] stay with it and be exported in its entirety to a single cell in the Excel spreadsheet (Column: description).
Whew, okay, I think that covers it. I have tried using the data access pages in 2000 and just exporting a report to Excel, and Word, and Word merge than transferring to Excel. I need to keep this really simple for the end-users (as in invisible!).
I need to export the results of a query into an Excel Spreadsheet (which is forwarded to an auction site .... they are requiring .xls format).
Problem: in order for the information to appear correctly once it is loaded to the auction site (html), it needs to include some html code around some of the fields but not all ...
Example:
Each of these would be in their own columns:
[title]
<html code> [description] <more code>
<more code> [image1]
<more code> [image2]
[duration]
[min-bid]
A secondary hitch is that the data entry people have to be able to change that html code occassionally when the owner wants a different color or font used or has a new paragraph of information that must be included with every record uploaded.
The code around the [description] stay with it and be exported in its entirety to a single cell in the Excel spreadsheet (Column: description).
Whew, okay, I think that covers it. I have tried using the data access pages in 2000 and just exporting a report to Excel, and Word, and Word merge than transferring to Excel. I need to keep this really simple for the end-users (as in invisible!).