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

reading an excel file in access

P: 55
In excel you can import data from an access database.How can you do the same in access?also when data is entered in excel it should reflect in access table.
Nov 30 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
In excel you can import data from an access database.How can you do the same in access?also when data is entered in excel it should reflect in access table.
You can link an excel file into Access. However, the data won't be fully live. Any changes to the excel file will have to be saved and the database refreshed before they are available in Access.
Dec 1 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.