how do I turn a Excel into a Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top