Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010

    Unanswered: how to get started

    hi everyone, a new here.....i had a large amount of data in excel and need to create a database.exporting is not the problem...i need to know the design of the many tables i shall need and relationships
    the data contains stock has the following
    -item code
    -item description
    -item unit
    -item quantity on hand

    i have 4 of such like spreadsheets, each containing a 1000 records.i need to merge them into an access database.where do i begin...kindly assist



  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    The amount of data, i.e. number of records, doesn't really come into this. The scenario you've given only requires a single table.
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts