General discussion

Locked

EXCEL DATABASE

By digitalshy ·
How do I use Excel to create a database?

This conversation is currently closed to new comments.

13 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

EXCEL DATABASE

by MtnSqs In reply to EXCEL DATABASE

Excel is NOT a database it is a SPREADSHEET. You can convert data from and Excel spreadsheet into an Access DB by saving as comma delimited and then reading it into Access.

Collapse -

EXCEL DATABASE

by digitalshy In reply to EXCEL DATABASE

The question was auto-closed by TechRepublic

Collapse -

EXCEL DATABASE

by proselyte In reply to EXCEL DATABASE

Like the previous post said, excel is not a database. What people usually mean when they refer to excel as a database is when you set a sheet like this<BR>
header1 | header2 | header3
data1 | data2 | data3
..
dataX | dataY | dataZ
This way eachrow will be one (database) record and each cell in a row will be one (database field). Then you can use the Data menu to do search,filter,sort operation.

But if you have more advanced needs, or have lots of data look at a real database.

Best regards,

Collapse -

EXCEL DATABASE

by digitalshy In reply to EXCEL DATABASE

The question was auto-closed by TechRepublic

Collapse -

EXCEL DATABASE

by donq In reply to EXCEL DATABASE

You can't!

You can create a database with Visual Basic, or the fastest way is to purchase a database product like Access and define the data you need to store in it.

Collapse -

EXCEL DATABASE

by digitalshy In reply to EXCEL DATABASE

The question was auto-closed by TechRepublic

Collapse -

EXCEL DATABASE

by MikeDale In reply to EXCEL DATABASE

Hi,
Excel is a very powerful database.

In Excel one column is equal to a field, and one row is equal to a record.

To set out a database, enter your field names, across your sheet, but in the same row. I.E.: put Surname in A2, put Firstname in B2, put Address in C2, and so on.
Then enter your data in to the fields, Excel will identify this format as a database automatically.
The 'Data' menu contains all the database features, and Excel has mant database functions you can use.
To search or filter your database, turn on the AutoFilter, CLICK on the 'Data' menu, SELECT 'Filter', from the sub menu SELECT 'AutoFilter'. One more tip select the Header row (the row you entered your field labels into) before turning on the 'AutoFilter'.

Good Luck
Mike Dale

Collapse -

EXCEL DATABASE

by digitalshy In reply to EXCEL DATABASE

The question was auto-closed by TechRepublic

Collapse -

EXCEL DATABASE

by nangsw In reply to EXCEL DATABASE

Excel is not a database it's a spread sheet but it can be like a database too.

If you want to make excel as database, you should convert it to DBF (dbase database) by "Save As" but before do it, make sure your data in one sheet.

Or you can useMS-ACCESS to connect excel spreadsheet (link table from access) but make sure, you already create "name range" of your excel data

good luck

Nanang

Collapse -

EXCEL DATABASE

by digitalshy In reply to EXCEL DATABASE

The question was auto-closed by TechRepublic

Back to Software Forum
13 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums