Inserting into an AccessDB from Excel worksheet
in [Getting Started]
|
Prev: copy records from a table in one file to a table in another file
Next: Setting up of a training database
From: Nicolai85 on 1 Jul 2008 03:02 Hi, I'm new to Access and kinda new to Excel as well. Anyway, I got a new summerjob, and they've asked me to make sort of a database system, which they can use to store some of the information they insert into different Excel sheets. I've tried to link the Excel sheets to Access and using the Get External Data method, but none of them works, since these sheets aren't very well made, atleast it doesn't seem so. So I want to copy the fields they insert their data in (in Excel) into queries I make in Access, but I can't figure out how? Any ideas? Nicolai
From: scubadiver on 1 Jul 2008 03:49 Before you even think about putting the information into Access I suggest you look at the data and see how its put together. The reason I say this is that a well-designed database is normalised which means it has to conform to certain data rules for it to be of use. Each table in a database will contain certain information and then these tables are then linked together using relationships. (At this point I think I appreciate what you might be thinking!). Don't rush into this. If you think about the design now you boss will be more than pleased. "Nicolai85" wrote: > Hi, I'm new to Access and kinda new to Excel as well. Anyway, I got a new > summerjob, and they've asked me to make sort of a database system, which they > can use to store some of the information they insert into different Excel > sheets. > > I've tried to link the Excel sheets to Access and using the Get External > Data method, but none of them works, since these sheets aren't very well > made, atleast it doesn't seem so. > > So I want to copy the fields they insert their data in (in Excel) into > queries I make in Access, but I can't figure out how? Any ideas? > > Nicolai >
From: Nicolai85 on 1 Jul 2008 04:00 Thanks, I will. But I still need an answer to my original question :) But a good tip, thanks! "scubadiver" wrote: > > Before you even think about putting the information into Access I suggest > you look at the data and see how its put together. The reason I say this is > that a well-designed database is normalised which means it has to conform to > certain data rules for it to be of use. > > Each table in a database will contain certain information and then these > tables are then linked together using relationships. (At this point I think I > appreciate what you might be thinking!). > > Don't rush into this. If you think about the design now you boss will be > more than pleased. > > "Nicolai85" wrote: > > > Hi, I'm new to Access and kinda new to Excel as well. Anyway, I got a new > > summerjob, and they've asked me to make sort of a database system, which they > > can use to store some of the information they insert into different Excel > > sheets. > > > > I've tried to link the Excel sheets to Access and using the Get External > > Data method, but none of them works, since these sheets aren't very well > > made, atleast it doesn't seem so. > > > > So I want to copy the fields they insert their data in (in Excel) into > > queries I make in Access, but I can't figure out how? Any ideas? > > > > Nicolai > >
From: scubadiver on 1 Jul 2008 04:21
File -> Get external data then either 'link' or 'import'. Warning: If the data isn't properly constructed for a database you will have problems later on. "Nicolai85" wrote: > Thanks, I will. > > But I still need an answer to my original question :) > > But a good tip, thanks! > > "scubadiver" wrote: > > > > > Before you even think about putting the information into Access I suggest > > you look at the data and see how its put together. The reason I say this is > > that a well-designed database is normalised which means it has to conform to > > certain data rules for it to be of use. > > > > Each table in a database will contain certain information and then these > > tables are then linked together using relationships. (At this point I think I > > appreciate what you might be thinking!). > > > > Don't rush into this. If you think about the design now you boss will be > > more than pleased. > > > > "Nicolai85" wrote: > > > > > Hi, I'm new to Access and kinda new to Excel as well. Anyway, I got a new > > > summerjob, and they've asked me to make sort of a database system, which they > > > can use to store some of the information they insert into different Excel > > > sheets. > > > > > > I've tried to link the Excel sheets to Access and using the Get External > > > Data method, but none of them works, since these sheets aren't very well > > > made, atleast it doesn't seem so. > > > > > > So I want to copy the fields they insert their data in (in Excel) into > > > queries I make in Access, but I can't figure out how? Any ideas? > > > > > > Nicolai > > > |