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



"Parvaiz" <(E-Mail Removed)> wrote in message
news:2F9D9095-4C4C-4BD6-8A87-(E-Mail Removed)...
> 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
>