how do I turn a Excel into a Access Database

A

Access_4_Dumb-e

I have a excel Spreadsheet with 4 different sections, the speadsheet is has
infroamtion that with allow me to look at my business infromation and find
TREND, based location of customers. I need to make the database so that I can
enter new items, update old items and confirm any item.

Also, the New items I need to load to the Database via an excel doc
 
J

John Nurick

It's not possible to just convert a complex Excel worksheet into an
Access database. You have to analyse your data and design an appropriate
structure of tables and relationships. After that you can import the
data from Excel and create the forms and reports you need. "Business
information" covers a pretty wide range, so one can't say much more.

Using Excel as the front end for data input (which seems to be what you
want) adds further complication.
 
Top