Creating an Access DB from Excel

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
 
A

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
 

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

Import Excel Workbook from Sharepoint 4
Access Qry in Excel Pivot 4
runtime error 3051 0
Excel VB to open Access DB 1
Excel crashes and restarts when accessing newly created worksheet 2
Exporting tables from SQL 2008 DB 3
Import same Excel ranges from many workbooks 3
Deleting MS JET OLE DB references in an Excel 2003 file 1

Top