Create an Access 2003 DB from Excel

Parvaiz

Guest

Posts: n/a

23rd Nov 2009

Hi, Can anyone please advise re best route.
I have to create an Access Databse based on existing Excel Workbooks.
There are several .xls workbooks and some of these contain multiple sheets.

I have imported in the past, but that was with 1 Workbook containing 1 Sheet.

Can anyone advise the best approach to start this off. I just need to be
pointed in the right direction. I think I can work it out then.

Thank you.
PS: Continuing to use the Excel workbooks is not an option as the department
wants to go 100% Access Database.

« Re: Best cohabitation Access 2007 ans SQL Server 2008 | Creating an Access DB from Excel »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access 2003 code to create Outlook 2003 Meeting Invites	Always OpenTo Suggestions	Microsoft Access VBA Modules	1	9th Apr 2009 05:25 PM
How do i create link with Access 2003 table/quary and Excel 2003 f	=?Utf-8?B?cm9nZXJkbWFzb24=?=	Microsoft Access	1	11th Oct 2007 08:35 PM
How to create a dropdown form in FP 2003 that is populated with data in an Access 2003 table	quinn_b@cox.net	Microsoft Frontpage	1	27th Feb 2007 10:09 AM
Access 2002 to Access 2003 Problem - Won't Create MDE in 2003	=?Utf-8?B?TGF0ZSBOaWdodCBDb2Rlcg==?=	Microsoft Access VBA Modules	2	29th Aug 2006 09:29 AM
Create a reporti n word 2003, using data in Excel 2003	=?Utf-8?B?RWQ=?=	Microsoft Word Document Management	1	21st Jul 2005 03:55 AM