Inserting into an AccessDB from Excel worksheet

  • Thread starter Thread starter Nicolai85
  • Start date Start date
N

Nicolai85

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
 
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.
 
Thanks, I will.

But I still need an answer to my original question :)

But a good tip, thanks!
 
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.
 
Back
Top