Excel -> Database

SharkBait said:
True, but if you had to choose between excel and access, which one would you choose?
Click to expand...

It depends on things like:

a] The amount of data [and how fast will it grow..if ever]
b] Do you want history of your data?
c] The amount of users who's going to INSERT/CHANGE the data [viewing is a different story].
d] Controlling the data [how,who,what,when it's entered]
--> If users are changing/adding ONE record at a time, presenting them with an Excel Sheet with 5,000 rows is not exactly good
--> However if users are "bulk" changing data, Excel tend to be very good at that.
e] Reporting Needs, this goes with [a] if it's alot of data and you
want to see the data differently or "query" it easily....Remember excel just gives you like "Raw" data, and you need to add more spreadsheets/lookups to make it "report worthy" etc etc. It's MUCH easier to create a report on Access that are printable and looks nice...

f] How long do you expect this "tool" to be functional....do you expect it to grow [more data,more users,more changes]?
 
Last edited:
diabolus said:
It depends on things like:

a] The amount of data [and how fast will it grow..if ever]
b] Do you want history of your data?
c] The amount of users who's going to INSERT/CHANGE the data [viewing is a different story].
d] Controlling the data [how,who,what,when it's entered]
--> If users are changing/adding ONE record at a time, presenting them with an Excel Sheet with 5,000 rows is not exactly good
--> However if users are "bulk" changing data, Excel tend to be very good at that.
e] Reporting Needs, this goes with [a] if it's alot of data and you
want to see the data differently or "query" it easily....Remember excel just gives you like "Raw" data, and you need to add more spreadsheets/lookups to make it "report worthy" etc etc. It's MUCH easier to create a report on Access that are printable and looks nice...

f] How long do you expect this "tool" to be functional....do you expect it to grow [more data,more users,more changes]?
Click to expand...

a] Currently at 1650 odd rows and growing at a rate of +-10 rows a week...
b] Yes, we need the history, currently going to a table...
c] Max 6 users who will be entering info.
d] The auto numbering is very important as this number is used to book everything...
e] The need to go back and report on stuff is low.
f] The "tool" will maybe used for a long while, but the amount of users will stay the same.
 
SharkBait said:
http://mybroadband.co.za/photos/showphoto.php?photo=8009&cat=500

This is how it is looking so far. :)

The problem I have now, is most of the drop down menus get the info from a table, but I want it to when you select on, it must put it in another table... Any help you guys can give me?
Click to expand...

Use insert queries. Get form data (from the variable names you've given) then use insert queries to add to the other table... The solution is extremely easy but to get M$ Access to do it might be a different story... My knowledge on Access is unfortunately that of a block of cheese...
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X