Discussion Locked

EXCEL DATABASE

0 helpful
13 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I use Excel to create a database?

13 replies

by mtnsqs

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.

by proselyte

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
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,

by donq

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.

by mikedale

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

by nangsw

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

by nangsw

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

This discussion is closed to new replies.