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

Form in Excel with access as database

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

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

Expert 100+
P: 634
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 ??

Dec 4 '08 #2

Post your reply

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