Excell 2003 spreadsheet to Access 2003

N

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
 
J

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error message importing from excell to access 1
can't import data excel spreadsheet 3
Excell t Access 2
Data export to excell truncated 1
carriage return error when importing excel into access 1
Linking to Excell 1
Select avaya cms server from shell option VBA 0
Automate export to Outlook 2

Top