Copy to a database

[Louis111]

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 Phillips]

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

Excel has a built in form, enter a simple table and goto Data>Form...

--
HTH

Bob

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

 

[Louis111]

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

 

[Gord Dibben]

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

Assuming you want everything in Excel.

Data>Form 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 Data>Form

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