Software

Ask something
Question Locked

excel-can it be both pushed and pulled from simultaneously?

0 helpful
2 replies

by alohaaaron

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

HI, I have an Excel worksheet I input data into that I'd like to have stored directly into a database. I'd also like to have the data in the database displayed in the same excel worksheet. Currently I am able to connect the database to the Excel worksheet with an ODBC connection, read the data from the database into the Excel worksheet by cycling through the records. Is it possible to have the data I input into Excel also saved into the database. Basically a two-way connection?

I have seen examples of linked Excel worksheets to Access but that is not what I want because then the data is stored in the Excel worksheet, not the database.

2 replies

by absolutely

To me, and I'm pretty sure this is
the "official" definition too, "off-topic"
means not having to do with IT. Your
question is not off-topic.

I think I understand your objection to a
linked table is that you want the data to
be in the .mdb file you save in Access, and
a linked table doesn't achieve that. If
that understanding is accurate, you can get
pretty close by adding a table now by
adding an Insert statement to the linked
table that isn't sufficient. You can get
the rest of the way by writing something in
VBA to run that query whenever data are
added to the spreadsheet.

This discussion is closed to new replies.