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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pass data from Excel to db table via odbc?

Status
Not open for further replies.
MTarkington

MTarkington

Programmer
Feb 14, 2001
73
US
Good morning,

Software: Excel 2003
Database: Intersystems Cache

Here is what I want to do:
I have an application that is tied to a Cache database. I will launch an Excel spreadsheet from within the application. The user will modify some fields that need to be passed back to certain fields in the Cache table. Is this possible?

Summed up, I am trying to find a way to send specific cells from Excel to specific fields in the open record of the Cache database.

Any ideas or suggestions?

TIA,
Mark
 
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
345
SkipVought
S
remeng
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
970
remeng
remeng
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
459
combo
combo
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
236
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
861
shytott
shytott

Part and Inventory Search

Sponsor

Back
Top