Creating an Access DB from Excel

[Parvaiz]

Hi, I have several Excel 2003 Workbooks. Smoe of these have multiple shetts.
I need to start creating an Access 2003 Database using the workbooks as
source.

My company wants to move away from the Excel workbooks and use only the new
database with its tables, queries reports etc.

Can someone just point me in the right direction as to where to start.
eg: Link or Import?
I think I can work it through then, but I just want to make sure I start off
correctly.
If anyone out there has had to create an Access Db from sereral Excel's that
contain multiple sheets you advice would be much appreciated. Cheers

 

[Alex Dybenko]

Hi,
you have to import sheets, not link, because you want to move away from
excel sheets, else you have to keep them
After import you have to decide on indexes, splitting one big table in to
several (lookup tables)
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[J_Goddard via AccessMonster.com]

Hi -

Before you do anything in MS Access, you must analyze the structure of the
data in your spreadsheets to determine what the entities ( = tables) and
fields (data type, size, etc) in your Access database will be, what the
primary keys of each will be, and the relationships between your tables are.
This is not necessarily going to be an easy process (depending on the
complexity of your data), because the entities are not always obvious. As a
start, look for groups of columns in your spreadsheets where the values are
the same across numerous rows - these are candidates to become rows in Access
tables. It is very unlikely that you will be able to look at a one
spreadsheet = one table scenario, unless your data is already structured to
some degree.

In designing a database, this step - analysis of the data structure - is
arguably the most critical, because if you don't get it right, you can
encounter all sorts of trouble later on.

Only after you have got the structure sorted out should you even think about
importing to Access.

There are numerous web sites you can consult to help you get started (MVP's -
can you post the best ones for him please?)

Good luck in your quest!

John