F
fcinelli
Is it possible to link Excel with access such that any changes made in
Excel will also occur in the access database? In other words, I need
to maintain a 2-way linkage between the 2, but I want all my data to
reside in the database, not the spreadsheet.
I understand that creating a Linked table in Access would accomplish
the linkage I want, but it creates problems when I link that table with
a Visio drawing...which is why the data needs to stay in the Access DB.
Anyone have any suggestions? I know that vba will accomplish this, but
I am not an expert in that field.
Any help would be appreciated. Thanks
Excel will also occur in the access database? In other words, I need
to maintain a 2-way linkage between the 2, but I want all my data to
reside in the database, not the spreadsheet.
I understand that creating a Linked table in Access would accomplish
the linkage I want, but it creates problems when I link that table with
a Visio drawing...which is why the data needs to stay in the Access DB.
Anyone have any suggestions? I know that vba will accomplish this, but
I am not an expert in that field.
Any help would be appreciated. Thanks