Can Excel upload data back to the database?

H

hon

Board Regular
Joined
Oct 10, 2005
Messages
73
I know Excel can import data from an external database via ODBC. Is it possible to do the reverse ie. inserting or even updating data in the database?
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
Does anyone have any idea on how to achieve this? Any advice is greatly appreciated.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Create .dat file from excel data for payment upload
Replies
1
Views
64
sailingmike49
S
L
  • Question
Draw data from website
Replies
2
Views
75
Lux Aeterna
L
JenniferMurphy
  • Question
Is there a good tutorial (book or video series) that can teach me how to make Excel behave like a database?
2 3
Replies
24
Views
432
JenniferMurphy
JenniferMurphy
A
  • Question
32000 rows, a formula for each day in each row, how do I make it faster?
Replies
6
Views
385
Peter_SSs
Peter_SSs
S
  • Question
Looking for Help to create an Excel or Access Database
Replies
5
Views
102
Micron
M

Forum statistics

Threads
1,214,950
Messages
6,122,428
Members
449,083
Latest member
Ava19

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top