Creating an Access DB from Excel

  • Thread starter Thread starter Parvaiz
  • Start date Start date
P

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
 
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
 
Back
Top