Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Embedded Excel

Status
Not open for further replies.
stoggers

stoggers

Vendor
May 30, 2001
93
US
Hi,

How would you embed an Excel spreadsheet in a table?

I can think of a couple of solutions - LOB's or DATALINK's but which would be the better solution for retrieving and updating the spreadsheet using the native application?

Regards,

Mike.
 
Sort by date Sort by votes
Hi,

If you want to transfer an Excel sheet completely, you can perhaps use the SYLK format, put it in a varchar or clob. In that format it is processable by other programs.

Regards,

Crox
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AMRICE
  • Locked
  • Question
Need Advise from Anyone Converting AS400 Macro to HAScript and HAScript Compatibility with Excel VBA
Replies
0
Views
559
AMRICE
AMRICE
MarcLodge
  • Locked
  • Question
Load mainframe db2 from Excel spreadsheet
Replies
7
Views
130
fredericofonseca
fredericofonseca
mpatter5
  • Locked
  • Question
QMF Report Center - Append Data To Excel?
Replies
6
Views
109
mpatter5
mpatter5
k5shah
  • Locked
  • Question
embedded SELECT in C
Replies
1
Views
40
MarcLodge
MarcLodge
SuzieW
  • Locked
  • Question
Problems with importing iSeries DB2 data into Excel
Replies
3
Views
77
SuzieW
SuzieW

Part and Inventory Search

Sponsor

Back
Top