Excell 2003 spreadsheet to Access 2003

[Nita]

I have a table in Excell 2003 and want to copy or export it to Access 2003
forming a new database. Can I do it, and if so how? The Excell table is 13
pages when printed.
Thanks,
nita

 

[Jeanette Cunningham]

Nita,
here is a link to info on how to do this

http://office.microsoft.com/en-us/access/HA010546501033.aspx

Jeanette Cunningham

 

[Jeff Boyce]

Nita

Before considering making your spreadsheet into a "database", have you
revisited your data and normalized the data structure? While is it usually
possible to import/link data in an Excel spreadsheet, you won't get the best
use of Access' relationally-oriented features/functions if you feed it
'sheet data.

If "relational" and "normalized" are not familiar terms, plan on spending
the time to learn and use these before migrating data from Excel to Access.
Access is "not a spreadsheet on steroids".

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/