Results 1 to 9 of 9
  1. #1
    brandy is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    9

    Import Help

    Hi all, i am relatively new to access and i faced some problems regarding importing datas, hope you guys can help me out.

    I have a CSV excel file which i want to import into my access database. However, my excel fields are first name, last name. But my access database tables are Full Name. Is there anyway for me to input some codes to make it work?



    Thank you in advance.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Import the CSV into its own table and then you can use queries to add the records to an existing table.

  3. #3
    brandy is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    9
    Could you give me an example? I'm very new to this sorry

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It is one of the questions asked when you invoke the Import Wizard. Just create a new table.

  5. #5
    brandy is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    9
    But is it possible to import into my current table?

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What is the problem with importing into a new table first?

  7. #7
    brandy is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    9
    Sounds like a good idea to import into a new table first. But do you know the next step after importing it into a new table? Like how do i combine the tables

  8. #8
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    PMFJI,

    Just a quick comment.
    However, my excel fields are first name, last name. But my access database tables are Full Name.
    Having the first name and last name is not a good practice. It violates 1NF because there are two pieces of data in one field.
    It is much, much easier to combine (concatenate) first and last names than it is to split them.

    I'm just sayin......

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by brandy View Post
    Sounds like a good idea to import into a new table first. But do you know the next step after importing it into a new table? Like how do i combine the tables
    You could do it with a query.

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

Similar Threads

  1. Replies: 13
    Last Post: 01-25-2016, 01:36 PM
  2. Replies: 3
    Last Post: 01-19-2015, 12:34 PM
  3. Replies: 10
    Last Post: 06-16-2014, 08:37 AM
  4. example of txt import
    By liebor in forum Import/Export Data
    Replies: 3
    Last Post: 03-09-2011, 09:08 AM
  5. Import from .CSV or .TXT
    By accesscoding in forum Import/Export Data
    Replies: 4
    Last Post: 02-12-2011, 06:05 AM

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