Problems with table linked to Excel

G

Guest

Hi,

1. I have an Access table based on an Excel file.
I want to be able to regularly update data on the
Access table from the Excel file.
At the moment I find that if I make a changes in
either the Excel file or the Access table, data in
both are immediately changed.
I want to be able to control when the Access file is
updated.
I have also found that any changes made in the Access
file, cause the Excel file to get messed up. Data no
longer appears in the right columns.
How can I stop Access from "updating" my Excel file?

2. Is it possible, to have something like a tag, which
associates data entered on a form to a particular
record? I have found that I cannot make changes to the
linked table from a form.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Autonumber field in Excel that behaves the same as Access 0
List all tables, including document structure 0
Integrating information from Word to Excel (not mail merge) 1
Linking data in MS Word into Excel 5
Consolidation Table from Different Excel Tabs with Different Format 1
Excel - Wich Function should I use? 1
Adding data to MS Access from csv file 0

Top