Excel Workbooks and a Single Database

RVFmal

RVFmal

Expert Member
Joined
Oct 27, 2004
Messages
2,172
Reaction score
214
I have information in approximately 15 Excel workbooks, each of which has approximately 5 worksheets. Some of the information in the work books is similar to infomation in another (products), but the pricing is different.

I want to collate all the information in a database (that can be updated automatically when I update the Excel workbook). I would also like to upload this database to a server where it can be accessed on line.

Which software is best suited to this sort of application. Please bear in mind I have no background in database work at all.
 
As you are already using Microsoft Excel the easiest would probably be to do the database in Access.
 
Best thing to do is ask some1 to set it up for you and then you use it from there. Making a database in Access is tricky if you dont know what you are doing. It's going to cost you 500-1000 for some1 to make the database in Access.
 
Person's advice is good. Setting it up could well be pretty messy as no database users normally do things in Excel that jar the nerves of a dba:D (like having different data types in the same column)
 
I seem to enjoy making life difficult for myself. I like to think of it as learning something new though.

I'll give it a bash, but if I get stone walled who do I call? (and no, Ghostbusters is not an option)
 
lol ...Ghostbusters
I'll be more that willing to help you with anything you might need.
0828393223 or just mail me
 
Person said:
lol ...Ghostbusters
I'll be more that willing to help you with anything you might need.
0828393223 or just mail me
Click to expand...

Going to start on it today, so keep your phone well charged and failing that, stay close to your PC.:)
 
Umm... @PERSON: this requirement may throw a spanner in the works -
I would also like to upload this database to a server where it can be accessed on line.
Click to expand...
If memory serves, Access is a single-user product and you may have to look at SQLServer, or something else with ODBC...
 
mbs said:
Umm... @PERSON: this requirement may throw a spanner in the works -

If memory serves, Access is a single-user product and you may have to look at SQLServer, or something else with ODBC...
Click to expand...

Access can shared on-line, but will be sensitive to the number of users, database sizes, complexity of queries and indexing. From the converts I've done of spreadsheets to database, the real problem is the lack of normalisation in spreadsheets, due to the ability to put anything in any cell.
 
Thanx bek - it's been ages since I looked at the product...
@Person: Given issues of input validation and data integrity as noted by bekdik, you should perhaps consider a forms front-end instead - check if RVF has a development purse, of course...
 
Guys I said i'll help him if he gets suck, till such time let him try. Im sure with googles help he can do it. As for making it shared on-line thats easy as long as it does not have to update auto. All you do is upload the database online and re-upload once you have updated.
 
Phew. Not as easy as I thought, but then I have had little time today to actually get down the nitty gritty.

Getting the database online is not high on my list of priorities right now to be honest. I am just want to collate the infoamtion from each of the sheets so that the data is easily accessible without having to open each of the workbooks individually when trying to access prices.

If I cannot do it, I will obviously be willing to pay should the need arise for me to employ the services of getting someone to do it for me.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X