Extract Data from Excel Form to Excel Database

Question

Hi there,

I have a pre defined excel form with 6 fields to be entered. I am looking for a method to automatically transfer the data entered in these 6 fields onto a database and reset all the 6 fields for a fresh entry. As multiple entries are made on the form, the database should automatically keep apending.

Answer 1

See also

http://www.rondebruin.nl/copy1.htm

Regards Ron de Bruin

http://www.rondebruin.nl/tips.htm

"Mayuresh" wrote in message news:*** Email address is removed for privacy ***...

Hi there,

I have a pre defined excel form with 6 fields to be entered. I am looking for a method to automatically transfer the data entered in these 6 fields onto a database and reset all the 6 fields for a fresh entry. As multiple entries are made on the form, the database should automatically keep apending.

Answer 2

If you mean a userform in VBA then see this article:

XL2000: How to Use a UserForm for Entering Data (Q213749)

http://support.microsoft.com/?id=213749

there is no built in support for clearing the controls on a userform.  You would have to write code like

me.textbox1.Value = ""

me.combobox1.ListIndex = -1

and so forth.  

---

--

Tom Ogilvy

note: If you receive an answer to your question - please mark that answer or answers so others know the question has been answered.

Answer 3

Take a look at Excel's data form feature - see Excel 2003 Data Form for a tutorial.

Answer 4

Hi Mayuresh, you may have better luck if you post your question in the Excel Forum as this one is for MS Word.

See http://social.answers.microsoft.com/Forums/en-US/category/officeexcel

All the best

Answer 5

Hi there,

I have a pre defined excel form with 6 fields to be entered. I am looking for a method to automatically transfer the data entered in these 6 fields onto a database and reset all the 6 fields for a fresh entry. As multiple entries are made on the form, the database should automatically keep apending.