Quote:
Originally Posted by vamsioracle  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 |
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
