Excel Spreadsheets to Access Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bill_a - 31 Dec 2006 15:35 GMT

I knowe that I can import a spreadsheet into Access to become a database. At
my work we currently use numerous spreadsheets to track different types of
data. I'd like to consolidate this into one area with one interface for ease
of use. Is it possible to import several spreadsheets into thus building one
database, which is accessed with one GUI?

Reply to this Message

Dave Patrick - 31 Dec 2006 16:09 GMT

Yes. After you import the data into Access you can build forms, queries and
reports in Access based on your tables and or queries.

Signature

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

>I knowe that I can import a spreadsheet into Access to become a database.
>At
[quoted text clipped - 4 lines]
> one
> database, which is accessed with one GUI?

Reply to this Message

(PeteCresswell) - 31 Dec 2006 16:48 GMT

Per bill_a:

> At
>my work we currently use numerous spreadsheets to track different types of
>data. I'd like to consolidate this into one area with one interface for ease
>of use. Is it possible to import several spreadsheets into thus building one
>database, which is accessed with one GUI?

Yes, but there will be nothing automatic about the process.

I'm guessing that by "import" you mean create MS Access tables which contain the
data tb put on the spreadsheets, write a UI to let the users maintain that data,
and then write Access VBA code to generate various spreadsheets on demand -
using the data from those tables.

Even with no specs at all, I'd opine that you're talking about a substantial
project - nothing that you'll knock out in a few weeks.

I'm doing one right now that tracks the performance of various bond funds, has a
UI that lets users manually update the data, allows users to copy paste data
into the DB from other sources, and creates various spreadsheets and charts to
show various performance criteria for various funds.

It's almost done and I've got a little over 500 hours in it. I'd guess 600 by
the time it's completely wrapped up.

Signature

PeteCresswell

Reply to this Message