Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2009
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post

    Hi! I am new to Access and was wondering if I was unable to import an Excel spread sheet due to import errors, how can I copy a record at a time into Access? Or can you?

    Thank you,
    Danielle

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Welcome to the Lounge!

    Look for a table named ... Import Errors; it may give a clue to the cause of the problems.

    If you want to import row by row, you could create a table in Access with the desired structure, then copy a row of data in Excel and paste it into a new record in the Access table.

Posting Permissions

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