Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Import (2000)

    Does an import from an Excel spreadsheet produce favorable results, or should I consider creating a database from scratch?

    The spreadsheet contains two name columns (Lname, Fname - Lname, Fname), starting and ending dates, and several account number columns.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Excel Import (2000)

    It should import cleanly - we often create new tables that way. You may want to establish a primary key for the table by putting an autonumber field on it, and you may need to check and make sure your dates are all valid dates, etc., but that should be about the only problems, and it really beats doing data entry.
    Wendell

Posting Permissions

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