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

Form in Excel with access as database

100+
P: 151
Hi all

I never tried this before, now i want to do a few experiments.

Can we create form (say employee entry form) in excel and can we place a button, where on click the data should be loaded to access database

please help me out

vamsi
Dec 4 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 634
@vamsioracle
Hi vamsi

The short answer is yes you can. I do this on an, (almost) daily basis for importing, amongs other things, timesheet data in to Access.

However, if you are going to enter all the information to import in to an Excel form, why not just use an Access form instead ??

The other thing is you will, perhaps, need is some knowlege of SQL and ADO connections and record sets (this is the only way I transfer data to/from Excel/Access - but there are otherways!). Have you any experiance with this or even VBA ??


MTB
Dec 4 '08 #2

Post your reply

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