Results 1 to 3 of 3
  1. #1
    dasaint80 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2018
    Posts
    1

    Creating access DB from Excel

    Hey all,

    I'm fairly new to access. I have an excel sheet that has alot of data input. I want to create a database and possibly a form so we can input/edit easier. Can some one guide me here?

    I import the Excel and I need to rename some fields because we use the same name for many fields. I can import it fine, but I get stuck when I try to create a form.

    I want to create a form so I can search the "wire#" field so I can edit the data for that wire # or create a new wire # if it's not there.


    But my issue is that the cable numbers are in sections "Axxxx" is for Audio cables and so on. Do I have to create a different database for each cable numbers section?

    Thanks in advance,
    Steve

    Sent from my SM-G955U using Tapatalk

  2. #2
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    Hmm, well Access unlike Excel is a relational database. Excel is a flat file *database*. Your spreadsheet would need to be divided into separate tables to be properly normalized. Have a look at...
    http://allenbrowne.com/AppHuman.html
    http://www.gpcdata.com/downloads/nor...pgonaccess.pdf

    That shouldbe done before you even begin to think about Forms.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Welcome to the forum.....

    First off, you should change some of the field names:
    Object names should be letters and numbers.
    Do not begin an object name with a number.
    NO spaces, punctuation or special characters (exception is the underscore) in object names
    Example of a bad field name: "RA#" (has the hash mark")

    You should *always* use forms to add/edit/delete data, not tables.


    I would strongly suggest you work through the tutorials (3) at Rogers Access Library
    Take the time to actually do them. Shouldn't take more than a couple of hours, but it will help you tremendously.


    Access is not anything close to Excel - they are two different animals. You should really analyze the Excel data and normalize the design.

    Here is some info on normalization. (there are 5 parts) to get you started.
    What is Normalization?
    =======================
    What Is Normalization, Part I: Why Normalization?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-02-2017, 04:17 PM
  2. Replies: 2
    Last Post: 09-26-2017, 09:18 AM
  3. Creating excel spreadsheet from access vba
    By nyneave in forum Programming
    Replies: 1
    Last Post: 10-12-2012, 09:59 AM
  4. Replies: 6
    Last Post: 10-17-2011, 11:16 PM
  5. Creating excel file from access vba
    By rparmar in forum Programming
    Replies: 3
    Last Post: 03-02-2010, 06:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums