Results 1 to 3 of 3
  1. #1
    GHanover is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    1

    creating field names in table without typing

    When creating a new table, I already have the field names typed out in an Excel file. When attempting to cut and paste into the table design view, I can only do one at a time. Is there a way to import field names en masse?
    Thanks


    Gary

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Yes

    You could import the SS as a Table.

    Search Import

  3. #3
    maximus's Avatar
    maximus is offline Expert
    Windows XP Access 2003
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    yes certainly as far as i understand you have your data typed out in an excel sheet with the top row as the field name try this out.

    click on File in Menu bar
    then click on import data
    then in the bottom select the file time you want to import as .xls(by default it is mdb)
    then browse and open the file
    follow on screen instruction
    you will be given an option to assign the first row as the field name.

    tell me if it solves your problem
    thanx my email silverback_bats@yahoo.co.in

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

Similar Threads

  1. Query to get column names in a table
    By access in forum Queries
    Replies: 1
    Last Post: 07-06-2009, 05:10 AM
  2. Query to get column names in a table
    By access in forum Forms
    Replies: 1
    Last Post: 07-01-2009, 02:50 PM
  3. Replies: 5
    Last Post: 03-31-2009, 09:16 PM
  4. Quick way to stuff field names into text field
    By kfinpgh in forum Programming
    Replies: 0
    Last Post: 01-04-2007, 01:13 PM
  5. How to extract names from 1 large field
    By Tepin in forum Access
    Replies: 1
    Last Post: 12-04-2006, 01:14 PM

Tags for this Thread

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