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

Pull data from Excel to Access DB via Access Forms

P: 1
Hi,
I do want to know how to connect Ms excel thru Vb coding in Access forms.
Please provide me step by step guidelines.
Thanks in Advance
Sep 13 '07 #1
Share this Question
Share on Google+
1 Reply


Stang02GT
Expert 100+
P: 1,208
You can do this simply by going to...

File
Get External Data
Link Tables
Select Excel in the drop down box
Locate where your spreadsheet is
and access will walk you through the rest
Sep 13 '07 #2

Post your reply

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