Hi,

I would like to create a form that is designed to copy entered data to a
database.

Any help would be appreciated.

Louis.

Excel 'database', Access, MS-SQL or what?

Excel has a built in form, enter a simple table and goto DataForm...

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Louis111" wrote in message
...
Hi,

I would like to create a form that is designed to copy entered data to a
database.

Any help would be appreciated.

Louis.

Hi,

Thanks for the response, i should have said that i am working in excel,

could you just clarify where to find the form in excel and what to do after
that,

thanks,

Louis


"Bob Phillips" wrote:

Excel 'database', Access, MS-SQL or what?

Excel has a built in form, enter a simple table and goto DataForm...

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Louis111" wrote in message
...
Hi,

I would like to create a form that is designed to copy entered data to a
database.

Any help would be appreciated.

Louis.

Bob knew you were entering data in Excel but your database could be anywhere.

Assuming you want everything in Excel.

DataForm is what you're looking for.

Say you want your database to encompass columns A through F

With titles/labels for the table in A1:F1, select A1:F1 and DataForm

You will get the message about Excel doesn't know which row to use as Labels.

Click on "Yes" to use row 1 as labels.

Start entering data in the fields provided in the Form.

Tab from field to field. When that record is complete, hit the ENTER key.

Just keep typing/tabbing/entering to add records.

Note the search criteria feature for finding specific records.


Gord Dibben MS Excel MVP



On Tue, 4 Mar 2008 09:14:00 -0800, Louis111
wrote:

Hi,

Thanks for the response, i should have said that i am working in excel,

could you just clarify where to find the form in excel and what to do after
that,

thanks,

Louis


"Bob Phillips" wrote:

Excel 'database', Access, MS-SQL or what?

Excel has a built in form, enter a simple table and goto DataForm...

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Louis111" wrote in message
...
Hi,

I would like to create a form that is designed to copy entered data to a
database.

Any help would be appreciated.

Louis.