By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Refresh Data from excel to access

P: n/a
Is it possible to update a spreadsheet from excel to access once it
has already been imported from excel. I imported the spreadsheet and
then made some changes can I update this in access?

Jun 7 '07 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Link the table rather than import. Then all you have to do to refresh
the table in access after changing something in Excel, right click on
table select 'Linked Tables Manager'. Check mark the table you want
to update and press OK.

Hope this helps,

Jun 7 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.